这条语句有错误吗?
CREATE TABLE orders (
cust_id int(5) NOT NULL,
order_id int(5) NOT NULL,
date timestamp(12),
instructions varchar(128),
creditcard char(16),
expirydate char(5),
PRIMARY KEY (cust_id,order_id)
) type=MyISAM ;
发生错误:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '(12),
instructions varchar(128),
creditcard char(16),
expirydate char(5),
PRIMAR' at line 4
------------------------------------------------------------------------------------------
说实话,没看出哪里错了,小弟新手一个,书上用MySQL 4.4通过了,小弟的5.5没通过,咋回事?
另外,是不是MySQL5.5不允许加入type=MyISAM?小弟的很多语句加入它都错了,尚不明白为什么,不过在这里我去掉type=MyISAM也没用啊?