DBeaver同时执行多条插入语句报错

2023-01-18 20:49:41

DBeaver同时执行多条插入语句报错

同时执行多行插入语句时报下面的错误

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 t_book(
	`id` int primary key auto_increment,
	`name` varchar(100),' at line 2


搜了半天发现是DBeaver设置的问题,修改连接配置的驱动属性:allowMultiqueries为true就好了
在这里插入图片描述

成功!

  • 作者:吹梦西州+
  • 原文链接:https://blog.csdn.net/qq_45209994/article/details/126702469
    更新时间:2023-01-18 20:49:41