-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSQL-create
More file actions
21 lines (20 loc) · 969 Bytes
/
SQL-create
File metadata and controls
21 lines (20 loc) · 969 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
CREATE TABLE BookStorage(
book_id INT PRIMARY KEY AUTO_INCREMENT,
title VARCHAR(50),
author VARCHAR(30),
price DECIMAL(8,2),
amount INT
);
INSERT INTO BookStorage(title, author, price, amount)
VALUES
("Мастер и Маргарита", "Булгаков М.А.", 670.99, 3),
("Собачье сердце", "Булгаков М.А.", 458.99, 8),
("Братья Карамазовы", "Достоевский Ф.М.", 799.00, 10),
("Капитанская дочка", "Пушкин А.С.", 399.49, 4),
("Собрание стихотворений", "Пушкин А.С.", 899.99, 15),
("Собрание стихотворений", "Бунин И.А.", 429.49, 7),
("Детство", "Толстой Л.Н.", 159.99, 3),
("Отрочество", "Толстой Л.Н.", 159.99, 4),
("Юность", "Толстой Л.Н.", 159.99, 9),
("Война и мир", "Толстой Л.Н.", 1159.99, 7)
;