mysql 语句问题
我建了个数据库后，建了表，语句如下：
CREATE TABLE order(
OrderId int(11) NOT NULL auto_increment,
UserId int(11) NOT NULL,
TotalMoney float NOT NULL default '0 ',
BuyDate date NOT NULL default '0000-00-00 ',
PayStatus char(10) NOT NULL default 'n ',
TransferStatus char(10) NOT NULL default 'n ',
PRIMARY KEY (OrderId)
) 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 'order
(
orderid int(11) not null auto_increment,
userid int(11) not null,
totalmo ' at line 1
不知道是什么意思，也看不出出了什么问题了

[解决办法]
CREATE TABLE order1(
OrderIdint NOT NULL ,
UserIdint NOT NULL,
TotalMoneyfloat NOT NULL default '0 ',
BuyDatesmalldatetime NOT NULL default '1900-00-00 ',
PayStatuschar NOT NULL default 'n ',
TransferStatus char NOT NULL default 'n ',
PRIMARY KEY (OrderId)
)

这样写才对~:)
[解决办法]
create table `order`