· 4 years ago · Sep 12, 2021, 06:34 PM
1CREATE TABLE IF NOT EXISTS `books` (
2 `id` int(6) unsigned NOT NULL,
3 `Name` varchar(200) NOT NULL,
4 `genre` int(6) unsigned NOT NULL,
5 `author` varchar(200) NOT NULL,
6 `date_pub` varchar(200) NOT NULL,
7 `pages` int(6) unsigned NOT NULL,
8 `price` int(6) unsigned NOT NULL,
9 `rating` real unsigned NOT NULL,
10 `pub_name` varchar(200) NOT NULL,
11 PRIMARY KEY (`id`)
12) DEFAULT CHARSET=utf8;
13INSERT INTO `books` (`id`, `Name`, `genre`, `author`, `date_pub`, `pages`, `price`, `rating`, `pub_name`) VALUES
14 (1, 'Капитанская дочка', 5, 'Александр Пушкин', '1836-01-01', 130, 150, 4.7, 'АСТ'),
15 (2, 'Отцы и дети', 1, 'Иван Тургенев', '1862-01-01', 240, 207, 4.7, 'Белый город')
16 ;
17
18