1.SET FOREIGN_KEY_CHECKS=0;取消外键约束
删除或更新数据失败
2.[Err] 1046 - No database selected
新建一个数据库,再运行SQL文件
3.[Err] 1050 - Table 't_department' already exists
4.[Err] 1062 - Duplicate entry '3' for key 'PRIMARY',主键重复
将主键设为自增
或者是修改主键
5.[Err] 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 '#
看有没有语法错误
不然的话考虑编码
6.MySQL建表时不要加引号,加引号是字符串;如果想要加,那应该是 `` 数字按键1左边的那个