在DBeaver中经常进行大量的数据插入,导致插入报错。
例如如下sql语句无法插入:
INSERT INTO szprslmes.mes_codepeople (F_Id,F_UserCodeId,F_UserName,F_DeleteMark,F_EnabledMark,F_CreatorTime,F_CreatorUserId,F_Description,F_LastModifyTime,F_LastModifyUserId,F_DeleteTime,F_DeleteUserId) VALUES
('08dda564-1375-43e7-8ddc-096dde270c53','1749260338589','**',0,1,'2025-06-07 09:39:00','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL),
('08dda564-1736-4562-8e2e-915429d575e9','1749260345631','**',0,1,'2025-06-07 09:39:06','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL),
('08dda564-1b17-4699-8ed6-fbec7ae6f2ea','1749260351340','**',0,1,'2025-06-07 09:39:13','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL),
('08dda564-1ef6-4728-8aac-5edc667cd75a','1749260358300','**',0,1,'2025-06-07 09:39:19','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL),
('08dda564-228f-4b15-8013-6731a6606ea4','1749260364377','**',0,1,'2025-06-07 09:39:25','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL),
('08dda564-2655-4712-83d5-0d2bb0c482df','1749260370971','**',0,1,'2025-06-07 09:39:31','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL),
('08dda564-2cea-443e-85a8-7f8ef763b766','1749260382029','**',0,1,'2025-06-07 09:39:43','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL),
('08dda564-3049-46e5-8ced-ee4f70b47ffe','1749260387661','**',0,1,'2025-06-07 09:39:48','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL),
('08dda564-33d8-4923-8b11-432d2d0f2310','1749260393683','**',0,1,'2025-06-07 09:39:54','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL),
('08dda564-3760-445a-8c28-d1d8e36cd8d5','1749260399599','**',0,1,'2025-06-07 09:40:00','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL);
INSERT INTO szprslmes.mes_codepeople (F_Id,F_UserCodeId,F_UserName,F_DeleteMark,F_EnabledMark,F_CreatorTime,F_CreatorUserId,F_Description,F_LastModifyTime,F_LastModifyUserId,F_DeleteTime,F_DeleteUserId) VALUES
('08dda564-3b46-4f0c-8f85-5303e25f4112','1749260406046','**',0,1,'2025-06-07 09:40:07','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL),
('08dda564-3eea-4487-8b7b-e22b66908744','1749260412050','**',0,1,'2025-06-07 09:40:13','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL),
('08dda564-42c2-4132-83fc-fae2fc31b48a','1749260418676','**',0,1,'2025-06-07 09:40:19','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL),
('08dda564-4613-414c-86ce-d256a0ecbe48','1749260424307','**',0,1,'2025-06-07 09:40:25','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL),
('08dda564-49e2-4aa1-869e-2ef55ea9995d','1749260430668','**',0,1,'2025-06-07 09:40:31','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL),
('08dda564-4d9f-43c9-830d-6fa6bec3b4fa','1749260436463','**',0,1,'2025-06-07 09:40:37','9f2ec079-7d0f-4fe2-90ab-8b09a8302aba','',NULL,NULL,NULL,NULL);
全选进行Ctrl+Enter运行无法正确执行。此时需要设置。右键数据库,编辑 “连接”。

更改allowMultiQueries为true。

更改后会重新进行连接数据库,此时就可以正常批量插入数据了。SQL语句之间要用分号进行分割。
DBeaver批量执行SQL语句的设置方法
2617

被折叠的 条评论
为什么被折叠?



