· 6 years ago · Jun 19, 2019, 12:24 AM
1CREATE TABLE IF NOT EXISTS 'e!' (
2`aa` int(11) unsigned NOT NULL auto_increment,
3`showName` TEXT NOT NULL default '',
4`startDateTime` DATETIME NOT NULL default '',
5`endDateTime` DATETIME NOT NULL default '',
6PRIMARY KEY (`aa`)
7) ENGINE=MyISAM DEFAULT CHARSET=utf8
8
9INSERT INTO e! (showname, startDateTime, endDateTime) VALUES('E! News ', '2012-05-03 19:00:00', '2012-05-03 20:00:00')
10
11INSERT INTO `e!` ...
12
13CREATE TABLE IF NOT EXISTS `e!` (
14`aa` int(11) unsigned NOT NULL auto_increment,
15`showName` TEXT NOT NULL default '',
16`startDateTime` DATETIME NOT NULL ,
17`endDateTime` DATETIME NOT NULL ,
18PRIMARY KEY (`aa`)
19) ENGINE=MyISAM DEFAULT CHARSET=utf8