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’,MySQL报错1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL-小白菜博客
这里的报错主要是因为第一行第二行倒数第二行中的符合使用错误
这里不能使用 ’ ,而要使用 ` (这个符号在笔记本键盘字母键上方数字键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;
MySQL报错1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL-小白菜博客
这里的报错是由于第一句不是使用 , 而是需要使用 ; 这样才能正确使用sql语句创建数据表。