CREATE TABLE `books` (
  `bookid` int NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `author` varchar(40) NOT NULL,
  `genre` varchar(50) NOT NULL,
  `copy_available` int NOT NULL,
  PRIMARY KEY (`bookid`)
 ) ENGINE=InnoDB;
 
 
INSERT INTO books (title, author, genre, copy_available) VALUES
('The Hunger Games', 'Suzanne Collins', 'Science Fiction', 3),
('System Collapse', 'Martha Wells', 'Science Fiction', 3),
('Eragon', 'Christopher Paolini', 'Fantasy', 2),
('Harry Potter', 'J.K. Rowling', 'Fantasy', 2),
('Dracula', 'Bram Stoker', 'Classic', 2),
('Of Mice and Men', 'John Steinbeck', 'Other', 2),
('Elon Musk', 'Walter Isaacson', 'Other', 2),
('PHP and MySQL for Dynamic Web Sites', 'Larry Ullman', 'Textbook', 5);