· 6 years ago · Oct 09, 2019, 08:08 AM
1
2CREATE TABLE IF NOT EXISTS `accounts` (
3 `id` int(11) NOT NULL,
4 `username` varchar(50) NOT NULL,
5 `password` varchar(255) NOT NULL,
6 `email` varchar(100) NOT NULL
7) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
8
9INSERT INTO `accounts` (`id`, `username`, `password`, `email`) VALUES (1, 'test', 'test', 'test@test.com');
10
11ALTER TABLE `accounts` ADD PRIMARY KEY (`id`);
12ALTER TABLE `accounts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;