· 8 years ago · Aug 17, 2018, 06:28 PM
1MySql insert statement driving me nuts
2DROP TABLE IF EXISTS `wp_beats`;
3CREATE TABLE .`wp_beats` (
4 `id` int(11) NOT NULL AUTO_INCREMENT,
5 `user_id` int(11) NOT NULL,
6 `name` varchar(512) NOT NULL,
7 `filename` varchar(512) NOT NULL,
8 `extension` varchar(4) NOT NULL,
9 `upload_date_time` datetime NOT NULL,
10 `genre_ID` int(11) NOT NULL,
11 `duration` varchar(14) DEFAULT NULL,
12 PRIMARY KEY (`id`) USING BTREE
13) ENGINE=InnoDB DEFAULT CHARSET=latin1;
14
15INSERT INTO `wp_beats` (name, user_id, filename, extension, duration, upload_date_time) VALUES ("Anthony test beat", "1", "4eaab724745ee", ".mp3", " 00:04:13.88", "2011-10-28 14:08:07")
16
17Failed to read auto-increment value from storage engine