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,而且是自增型的。