数据库数据的插入

JY数据库数据的插入

USE JY
GO

1、给表reader插入数据

INSERT INTO reader
VALUES
('r001','李德海','男','信息工程系'),
('r002','刘承运','男','信息工程系'),
('r003','安歌','女','涉外教育系'),
('r004','谢嫣然','女','涉外教育系'),
('r005','陈静玉','女','涉外教育系'),
('r006','李媛媛','女','行政管理系'),
('r007','胡锦波','男','行政管理系'),
('r008','蔡明伟','男','行政管理系');
GO

SELECT * FROM reader  --查询是否插入成功
GO

2、给表record插入数据

INSERT INTO record
VALUES
('r001','b003','2014-01-11','2014-02-13','NULL'),
('r001','b005','2014-01-13','2014-02-10','NULL'),
('r004','b001','2014-03-15','2014-04-15','NULL'),
('r004','b008','2014-03-11','2014-04-12','NULL'),
('r006','b001','2014-04-12','2014-05-17','NULL'),
('r007','b006','2014-05-13','2014-06-10','NULL'),
('r008','b008','2014-06-14','2014-07-11','NULL'),
('r008','b007','2014-08-12','2014-09-12','NULL');
GO

SELECT * FROM record  --查询是否插入成功
GO

3、给表book插入数据

INSERT INTO book
VALUES
('b001','葵花宝典','978-7-121-21013-5','郭晨','人民邮电出版社','11','41.00'),
('b002','九阳神功','978-7-121-22013-5','王潇','电子工业出版社','12','42.00'),
('b003','无影脚','978-7-121-23013-5','张越','电子工业出版社','13','43.00'),
('b004','截拳道','978-7-121-24013-5','李小龙','电子工业出版社','14','44.00'),
('b005','蛤蟆功','978-7-121-25013-5','杨诗涵','电子工业出版社','15','45.00'),
('b006','如来神掌','978-7-121-26013-5','王积旺','人民邮电出版社','16','46.00'),
('b007','铁布衫','978-7-121-27013-5','南翔宇','人民邮电出版社','17','47.00'),
('b008','金钟罩','978-7-121-28013-5','无名','人民邮电出版社','18','48.00');
GO

SELECT * FROM book  --查询是否插入成功
GO