问题
使用DBeaver执行以下sql语句:
insert into course (cname,cteacher,cpoint) values('数学','张明',85);
insert into course (cname,cteacher,cpoint) values('英语','王悦',85);
出现如下错误:
SQL 错误 [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 'insert into course (cname,cteacher,cpoint) values('英语','王悦',85)' at line 2
解决办法
- 选中多条sql语句后,使用快捷键alt+x即可运行
- 在localhost上右键,选择编辑,弹出连接设置界面,将驱动属性中的allowMultiQueries设置为TRUE