1 CREATE TABLE `mytable` (
2 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
4 `flag` tinyint(4) NOT NULL DEFAULT '0',
6 UNIQUE KEY `date` (`date`)
7 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9 INSERT into /* inline comment */ mytable VALUES (1, 'ัะตัั');
11 SELECT * FROM `mytable`; -- line-comment"
15 INSERT INTO `MyTable` (`Id`, `Name`)
18 insert into mytable values (1, 'one'), (2, 'two');
20 insert into mytable (id, name) values (1, 'one'), (2, 'two');