SQL语句快速添加表的记录

 

1、 首先这张表名为users，主键是userId。建表的语句如下：

create database spdb;

create table users(
userId int primary key identity(1,1),
username varchar(20),
passwd varchar(20),
email varchar(30),
grade int);

2、 在表中插入一些数据：

insert into users values('admin','admin','admin@sohu.com',1)
insert into users values('shunping','shunping','shunping@sohu.com',1)
insert into users values('tester1','tester1','tester1@sohu.com',5)
insert into users values('tester2','tester2','tester2@sohu.com',5)
insert into users values('tester3','tester3','tester3@sohu.com',1)
insert into users values('tester4','tester4','tester4@sohu.com',6)
insert into users values('tester5','tester5','tester5@sohu.com',2)
insert into users values('tester6','tester6','tester6@sohu.com',1)
insert into users values('tester7','tester7','tester7@sohu.com',2)

3、下面就是关键的快速增加记录的语句了：

insert into users(username,passwd,email,grade) select username,passwd,email,grade from users;

4.、该表的主键是userId，而且是自增型的。