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
........

