I am having a syntax error and I really don't understand why I am getting it.
I have to make a copy of a table in a different webhost who unfortunately doesn't have phpmyadmin or anything similar, just mySQL support.
Anyway, I created my table using this code:
Code: Select all
CREATE TABLE `releases` (
`key` int(4) NOT NULL auto_increment,
`artist` varchar(64) NOT NULL default '',
`album` varchar(128) NOT NULL default '',
`price` varchar(6) NOT NULL default '',
`relnum` varchar(10) NOT NULL default '',
`notes` varchar(32) NOT NULL default '',
`format` varchar(48) NOT NULL default '',
`pid` varchar(4) NOT NULL default '',
PRIMARY KEY (`key`)
) TYPE=MyISAM ;Code: Select all
INSERT INTO `releases` VALUES ('', 'NAER MATARON', 'Up From The Ashes', '0', 'BLR/CD003', 'sold out', 'CD' , '');
INSERT INTO `releases` VALUES ('', 'HORRIFIED', 'Animal', '10', 'BLR/CD004', '', 'Digipack' , '1');
INSERT INTO `releases` VALUES ('', 'DESCEND', 'Beyond The Realm Of Throes', '7', 'BLR/CD005', '', 'CD' , '2');
INSERT INTO `releases` VALUES ('', 'AFTERMATH', 'Eyes of tomorrow', '10', 'BLR/CD006', 're-release', 'CD' , '3');
...
...You have an error in your SQL syntax near 'INSERT INTO `releases` VALUES ('', 'HORRIFIED', 'Animal', '10', 'BLR/CD004', '',' at line 3
Am I not seeing something so obvious?
Any help appreciated.
Thanks in advance.