MySQL报错1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL
navicat中添加mysql语句报错报错一: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 ‘‘monkey_user’’ at line 11064 - You
navicat中添加mysql语句报错
报错一:
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 ‘‘monkey_user’’ at line 1
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 ‘‘monkey_user’(
USER_ID varchar(32) not null,
USER_’ at line 1
mysql> drop table if exists ‘monkey_user’,
这里的报错主要是因为第一行第二行倒数第二行中的符合使用错误
这里不能使用 ’ ,而要使用 ` (这个符号在笔记本键盘字母键上方数字键1的左边,与~共用一个按键)
报错二:
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 'create table Imonkey_user
(
USER_ID varchar(32) not null,
’ at line 3
mysql> drop table if exists Imonkey_user
;
这里的报错是由于第一句不是使用 , 而是需要使用 ; 这样才能正确使用sql语句创建数据表。
更多推荐
所有评论(0)