iWTZ71zp

1set sql_mode = 'STRICT_ALL_TABLES'
2SET SQL_SAFE_UPDATES = 0;
3
4DROP TABLE IF EXISTS `book`;
5
6CREATE TABLE book (
7book_id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
8book_title VARCHAR(255) NOT NULL,
9book_format VARCHAR(30) NOT NULL,
10book_numberPage int,
11book_authors VARCHAR(30) NOT NULL,
12book_publisher VARCHAR(30) NOT NULL,
13book_year int(4) NOT NULL,
14book_edition int NOT NULL,
15book_ISBN10 VARCHAR(20) NOT NULL,
16book_ISBN13 VARCHAR(20) NOT NULL
17);
18
19DROP TABLE book;
20
21CREATE TABLE book (
22book_id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
23book_title VARCHAR(255) NOT NULL,
24book_format ENUM('paperback', 'hardcover') NOT NULL ,
25book_numberPage int,
26book_authors VARCHAR(30) NOT NULL,
27book_publisher VARCHAR(30) NOT NULL,
28book_year int(4) NOT NULL,
29book_edition int NOT NULL,
30book_ISBN10 VARCHAR(20) NOT NULL,
31book_ISBN13 VARCHAR(20) NOT NULL
32);
33
34INSERT INTO book (book_title, book_format, book_numberPage, book_authors , book_publisher , book_year , book_edition , book_ISBN10 ,book_ISBN13)
35VALUES ("An Introduction to Database Systems", "paperback", 452, "C.J. Date" , "Pearson" , 2003 , 8 , 0321197844 , "978-0321197849");
36
37INSERT INTO book (book_title, book_format, book_numberPage, book_authors , book_publisher , book_year , book_edition , book_ISBN10 ,book_ISBN13)
38VALUES ("C plus plus for Beginners: First steps of C ++ Programming Language ", "paperback", 162, "	
39Robert W. James" , " Independently" , 2018 , 8 , 1717700888 , "978-1717700889");
40
41INSERT INTO book (book_title, book_format, book_numberPage, book_authors , book_publisher , book_year , book_edition , book_ISBN10 ,book_ISBN13)
42VALUES ("An Introduction to Database Systems", "paperback", 452, "C.J. Date" , "Pearson" , 2001 , 7 , 0201787229 , "978-0201787221");
43
44INSERT INTO book (book_title, book_format, book_numberPage, book_authors , book_publisher , book_year , book_edition , book_ISBN10 ,book_ISBN13)
45VALUES ("An Introduction to Database Systems", "paperback", 840, "C.J. Date" , "Addison-Wesley" , 1994 , 6 , 9780201543292 , "978-0201543292");
46
47INSERT INTO book (book_title, book_format, book_numberPage, book_authors , book_publisher , book_year , book_edition , book_ISBN10 ,book_ISBN13)
48VALUES ("Introduction to Computing Systems: From Bits and Gates to C and Beyond", "paperback", 656, "Sanjay J. Patel" , "McGraw-Hill Education" , 2003 , 2 , 0072467509 , "978-0072467505");
49
50INSERT INTO book (book_title, book_format, book_numberPage, book_authors , book_publisher , book_year , book_edition , book_ISBN10 ,book_ISBN13)
51VALUES ("Fear: Trump in the White House", "Hardcover", 448, "Bob Woodward" , "Simon & Schuster" , 2018 , 1 , 1501175513 , "978-1501175510");
52
53INSERT INTO book (book_title, book_format, book_numberPage, book_authors , book_publisher , book_year , book_edition , book_ISBN10 ,book_ISBN13)
54VALUES ("Girl, Wash Your Face: Stop Believing the Lies About Who You Are so You Can Become Who You Were Meant to Be", "Hardcover", 240, "Rachel Hollis" , "Thomas Nelson" , 2018 , 1 , 1400201659 , "978-1400201655");
55
56Select * from book;
57
58UPDATE book SET book_authors = 'Christopher' WHERE book_authors = 'C.J. Date';
59
60#DELETE FROM book WHERE book_authors = 'Christopher';
61
62Select book_title , book_format , book_numberPage , book_authors , book_publisher , book_year , book_edition , book_ISBN10 from book ;
63
64Select book_title from book;
65
66select book_authors from book where book_title = 'An Introduction to Database Systems';
67
68ALTER TABLE book ADD book_language varchar(25);
69
70update book set book_language = 'english';
71
72DROP TABLE book;