· 9 years ago · Dec 20, 2016, 06:58 AM
1
2
3CREATE TABLE IF NOT EXISTS `children` (
4 `id` int(11) NOT NULL,
5 `name` varchar(255) NOT NULL,
6 `city` varchar(100) NOT NULL,
7 `gender` varchar(6) NOT NULL,
8 `behaviour` varchar(4) NOT NULL,
9 `state` varchar(20) NOT NULL
10) ENGINE=InnoDB DEFAULT CHARSET=utf8;
11
12
13ALTER TABLE `children`
14 ADD PRIMARY KEY (`id`);
15
16
17
18ALTER TABLE `children`
19 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;