SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
CREATE TABLE IF NOT EXISTS `books` (
`ID` int(11) NOT NULL auto_increment,
`BookName` varchar(100) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=57 ;
INSERT INTO `books` (`ID`, `BookName`) VALUES
(1, 'book 1'),
(2, 'book 2'),
(3, 'book 3'),
(4, 'book 4'),
(5, 'book 5'),
(6, 'book 6'),
(7, 'book 7'),
(8, 'book 8'),
(9, 'book 9'),
(10, 'book 10'),
(11, 'book 11'),
(12, 'book 12'),
(13, 'book 13'),
(14, 'book 14'),
(15, 'book 15'),
(16, 'book 16'),
(17, 'book 17'),
(18, 'book 18'),
(19, 'book 19'),
(20, 'book 20'),
(21, 'book 21'),
(22, 'book 22'),
(23, 'book 23'),
(24, 'book 24'),
(25, 'book 25'),
(26, 'book 26'),
(27, 'book 27'),
(28, 'book 28'),
(29, 'book 29'),
(30, 'book 30'),
(31, 'book 31'),
(32, 'book 32'),
(33, 'book 33'),
(34, 'book 34'),
(35, 'book 35'),
(36, 'book 36'),
(37, 'book 37'),
(38, 'book 38'),
(39, 'book 39'),
(40, 'book 40'),
(41, 'book 41'),
(42, 'book 42'),
(43, 'book 43'),
(44, 'book 44'),
(45, 'book 45'),
(46, 'book 46'),
(47, 'book 47'),
(48, 'book 48'),
(49, 'book 49'),
(50, 'book 50'),
(51, 'book 51'),
(52, 'book 52'),
(53, 'book 53'),
(54, 'book 54'),
(55, 'book 55'),
(56, 'book 56');
|
Download
