· 6 years ago · Jul 05, 2019, 02:02 PM
1DROP TABLE IF EXISTS `students`;
2CREATE TABLE `students` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `name` varchar(50) NOT NULL DEFAULT '',
5 `gender` varchar(1) NOT NULL DEFAULT '',
6 `address` varchar(255) NOT NULL DEFAULT '',
7 `telephone` varchar(50) NOT NULL DEFAULT '',
8 `email` varchar(60) NOT NULL DEFAULT '',
9 PRIMARY KEY (`id`)
10) ENGINE=InnoDB DEFAULT CHARSET=latin1;