创建mysql数据库出现ERROR 1064 (42000): You have an error in your SQL syntax; check the ......问题

drop table if exists UserTb1;
create table UserTb1
(
id int(11) primary key auto_increment,
username VARCHAr(20) ,
password VARCHAr(30)
);

drop table if exists EscapedPeopleTb1;
create table EscapedPeopleTb1
(
id int(11) primary key auto_increment,
name VARCHAr(20) not null,
gender VARCHAr(20),
age int(11),
IDNo VARCHAr(20),
address VARCHAr(100),
crimeRecord varchar(200),
pic VARCHAr(100)
);

drop table if exists VehicleInfoTb1;
create table VehicleInfoTb1
(
id int(11) primary key auto_increment,
name varchar(20),
idno varchar(20),
license varchar(20),
createTime varchar(30),
faultRecord varchar(300),
penalty double(18)
)
;
drop table if exists UploadFileTb1;
create table UploadFileTb1
(
id int(11) primary key auto_increment,
uploadTime VARCHAr(20),
FileDesc VARCHAr(200),
FilePath VARCHAr(100)
)
;

mysql> create table VehicleInfoTb1
-> (
-> id int(11) primary key auto_increment,
-> name varchar(20),
-> idno varchar(20),
-> license varchar(20),
-> createTime varchar(30),
-> faultRecord varchar(300),
-> penalty double(18)
-> )
-> ;
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 ')
)' at line 9

double(18) 修改一下

mysql> create table VehicleInfoTb1
-> (
-> id int(11) primary key auto_increment,
-> name varchar(20),
-> idno varchar(20),
-> license varchar(20),
-> createTime varchar(30),
-> faultRecord varchar(300),
-> penalty double
-> );
Query OK, 0 rows affected (0.09 sec)

mysql>

通过.

near 'creat database shiyun，create少写了字母。

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息