#1064 - You have an error in your SQL syntax

   2026-04-13 3330
核心提示:这样写语法不对吧, values后面每一行不能简单用逗号连, 应该这样写insert into 'pre_common_district' (`id`, `name`, `
这样写语法不对吧, values后面每一行不能简单用逗号连, 应该这样写
insert into 'pre_common_district' (`id`, `name`, `level`, `usetype`, `upid`, `displayorder`)
select 12599, '河东街道', 4, 0, 1695, 0 union
select 12600, '玉泉镇', 4, 0, 1695, 0 union
........

或者你为每一行写一个insert into语句也行,如:
insert into 'pre_common_district' (`id`, `name`, `level`, `usetype`, `upid`, `displayorder`)
values (12599,'河东街道', 4, 0, 1695, 0)

insert into 'pre_common_district' (`id`, `name`, `level`, `usetype`, `upid`, `displayorder`)
values (12600, '玉泉镇', 4, 0, 1695, 0)

......追问
不行的,按第一种方法出现:
#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 'union), (12600, '玉泉é', 4, 0, 1695, 0 union), (12601, '红星乡', 4, 0, 16' at line 1
追答
table 和 字段名应该不用加引号,  
insert into pre_common_district (id, name, level, usetype, upid, displayorder)
select 12599, "河东街道", 4, 0, 1695, 0 union
select 12600, "玉泉镇", 4, 0, 1695, 0 union
........
 
举报收藏 0评论 0
更多>相关评论
暂时没有评论,来说点什么吧
更多>同类茂名资讯
  • admin
    加关注0
  • 没有留下签名~~
推荐图文
推荐茂名资讯
点击排行
💬 有疑问?