mysql 中的1064_mysql中的错误#1064

参见英文答案 >

1064 error in CREATE TABLE … TYPE=MYISAM                                    4个

我一直收到这个错误：

1064 – 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 ‘TYPE=MyISAM AUTO_INCREMENT=58’ at line 11

这是我的查询：

CREATE TABLE `tbl_cart` (

`ct_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,

`pd_id` int( 10 ) unsigned NOT NULL default '0',

`ct_qty` mediumint( 8 ) unsigned NOT NULL default '1',

`ct_session_id` char( 32 ) NOT NULL default '',

`ct_date` datetime NOT NULL default '0000-00-00 00:00:00',

PRIMARY KEY ( `ct_id` ) ,

KEY `pd_id` ( `pd_id` ) ,

KEY `ct_session_id` ( `ct_session_id` )

) TYPE = MYISAM AUTO_INCREMENT =58;

帮帮我问题是什么……