-
Notifications
You must be signed in to change notification settings - Fork 2
/
INSERT.sql
104 lines (90 loc) · 2.75 KB
/
INSERT.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
use Bookstore;
insert into customer(caddress, cname, cemail)
values ('HCM', 'A', '[email protected]');
insert into customer(caddress, cname, cemail)
values ('HCM', 'B', '[email protected]');
insert into customer(caddress, cname, cemail)
values ('HCM', 'C', '[email protected]');
insert into customer(caddress, cname, cemail)
values ('HCM', 'D', '[email protected]');
insert into customer(caddress, cname, cemail)
values ('HCM', 'E', '[email protected]');
insert into customer(caddress, cname, cemail)
values ('HCM', 'F', '[email protected]');
insert into customer(caddress, cname, cemail)
values ('HCM', 'G', '[email protected]');
insert into book_isbn
values ('1111', 'science', 'book 1', 1000);
insert into book_isbn
values ('2222', 'action', 'book 2', 2000);
insert into book_isbn
values ('3333', 'action', 'book 2', 2001);
insert into book_isbn
values ('4444', 'action', 'book 2', 2001);
insert into book_prop
values ('1111', 'Newton');
insert into book_prop
values ('1111', 'Einstein');
insert into book_prop
values ('1111', 'gravity');
insert into book_prop
values ('2222', 'Einstein');
insert into book_prop
values ('3333', 'gravity');
insert into book_prop
values ('4444', 'Einstein');
insert into book_prop
values ('4444', 'gravity');
insert into pbook
values ('1111', cast('1/1/2000' as datetime), 'in stored');
insert into pbook
values ('1111', cast('1/1/2000' as datetime), 'in stored');
insert into pbook
values ('1111', cast('1/1/2000' as datetime), 'waiting');
insert into bill(issue, price, purchase_date, quantity)
values ('not finished', 2000, cast('1/12/2000' as datetime), 2);
insert into bill(issue, price, purchase_date, quantity)
values ('not finished', 1000, cast('1/12/2000' as datetime), 1);
insert into author(aname, pen_name)
values ('a', 'Pete');
insert into author(aname, pen_name)
values ('b', 'Val');
declare @date_now date;
set @date_now = cast('2020-1-13' as date);
insert into write(isbn, aid, date_published)
values ('1111', 1, @date_now);
set @date_now = getdate();
insert into write(isbn, aid, date_published)
values ('2222', 1, @date_now);
set @date_now = getdate();
insert into write(isbn, aid, date_published)
values ('3333', 1, @date_now);
set @date_now = getdate();
insert into write(isbn, aid, date_published)
values ('4444', 1, @date_now);
insert into ebook(isbn)
VALUES('2222')
insert into ebook(isbn)
VALUES('3333')
insert into pbook(isbn)
VALUES('4444')
insert into pbuy
values (1, 8, 1);
insert into pbuy
values (4, 8, 2);
insert into pbuy
values (5, 8, 1);
--delete from pbuy where 1 = 1;
--delete from book_isbn where 1 = 1;
select * from book_prop;
select * from author;
select * from write;
select * from customer;
select * from pbook;
select * from pbuy;
select * from book_isbn;
select * from bill;
select * from ebuy;
select * from ebook;
--------------------
use smallDB20161002;