mysql> create table demotable ( userid int not null auto_increment primary key, username varchar(100), userage int, useraddress varchar(200), usercountryname varchar(100) , ismarried boolean, );
这将产生以下输出，即错误 -
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 10
要消除上述错误，您需要删除最后一个逗号(,)。查询如下以消除错误 -
mysql> create table demotable ( userid int not null auto_increment primary key, username varchar(100), userage int, useraddress varchar(200), usercountryname varchar(100), ismarried boolean );query ok, 0 rows affected (1.04 sec)
以上就是修复 mysql 数据库错误 #1064？的详细内容。