· 8 years ago · Nov 27, 2017, 05:06 PM
1CREATE TABLE IF NOT EXISTS `articles` (
2 `article_id` int(5) NOT NULL AUTO_INCREMENT,
3 `title` varchar(200) NOT NULL,
4 `category` varchar(100) NOT NULL,
5 PRIMARY KEY (`article _id`)
6) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
7
8INSERT INTO `articles` (`article_id`, `title`, `category`) VALUES
9 (1, 'Java Concurrency', 'Java'),
10 (2, 'Hibernate HQL ', 'Hibernate'),
11 (3, 'Spring MVC with Hibernate', 'Spring');