INSERT INTO area (id, code, name1, citycode) VALUES
(1, '110101','东城区', '110100'), --就这儿了
(2, '110102', '西城区', '110100')
INSERT INTO area (id, code, name1, citycode)
SELECT 1, '110101','东城区', '110100'
UNION ALL
SELECT 2, '110102', '西城区', '110100'
(1, '110101','东城区', '110100'), --就这儿了
(2, '110102', '西城区', '110100')
INSERT INTO area (id, code, name1, citycode)
SELECT 1, '110101','东城区', '110100'
UNION ALL
SELECT 2, '110102', '西城区', '110100'
create table Area(id int,code varchar(10),name1 nvarchar(10),citycode varchar(10))
INSERT INTO area (id, code, name1, citycode) VALUES
(1, '110101','东城区', '110100'),
(2, '110102', '西城区', '110100')
insert into xxxx
values()
insert into xxxx
values()
insert into xxxx
values()
方法2、用select 把数据查出来再插入,1楼已经写出来了