在使用mysqlcc中遇到的语法问题.

Question

补充..我用的是mysql5.0的版本..

Answer 1

create table ABIS_MSG
(
   `MID`                            decimal(64 ,0) null,
   DID                            decimal(64 ,0) null,
   `LOCALTIME`                   datetime null,
   CHNLTYPE                       integer null,
   TIMESLOT                       integer null,
   RSL                            integer null,
   PD                             integer null,
   LAYER3                         integer null,
   primary key ()  -- ????
);
`mid` 和 `LOCALTIME`  是保留字, 用 ``