· 8 years ago · Jun 12, 2018, 06:38 PM
1CREATE TABLE IF NOT EXISTS `persons` ( `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT, `last_name` varchar(50) NOT NULL, `first_name` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;
2
3first three lines of file are:
4"Knautz Clyde
5","Rosenthal Ron
6","Johnson Diane
7
8SELECT * FROM persons LIMIT 3
9returns: Empty set (0.00 sec)