· 8 years ago · Aug 13, 2018, 05:48 PM
1MySQL : Table optimization word 'guest' or memberid in the column
2CREATE TABLE IF NOT EXISTS `Table2`
3 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
4 memberid varchar(20) NOT NULL,
5 `Time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
6 status tinyint(4) NOT NULL,
7 PRIMARY KEY (`id`)
8 ) ENGINE=InnoDB;