· 8 years ago · Jul 19, 2018, 05:20 PM
1/*
2 Books Table
3*/
4CREATE TABLE IF NOT EXISTS `books` (
5 `id` int(10) NOT NULL auto_increment,
6 `name` varchar(255) NOT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9
10
11INSERT INTO `books` (`id`, `name`) VALUES
12 (1, 'Harry Potter and the Philosophers Stone');