· 7 years ago · Nov 26, 2018, 05:42 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
4 PRIMARY KEY (`id`)
5) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
6
7--
8-- table `users`
9--
10
11INSERT INTO `users` (`id`, `name`) VALUES
12(1, 'UserOne'),
13(2, 'UserTwo');