· 8 years ago · Aug 03, 2018, 07:06 AM
1ALTER TABLE <tablename> AUTO_INCREMENT=1;
2
3DROP TABLE IF EXISTS `tablename`;
4CREATE TABLE `tablename`
5(`id` int(11) NOT NULL AUTO_INCREMENT,
6 `fld1` int(11) DEFAULT NULL,
7 `fld2` text CHARACTER SET utf8,
8 PRIMARY KEY (`id`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8;