Th3Boss Posted March 29, 2013 Share Posted March 29, 2013 This is the error I keep getting and I cant figure out where the error is. SQL query: -- -- Dumping data for table `ships` -- INSERT INTO `ships` (`Ship_Name`, `typeID`, `high`, `mid`, `low`, `rig`, `drone`) VALUES ('Bantam', 582, 3, 4, 2, 3, 5, ''), ('Condor', 583, 4, 4, 2, 3, 0, ''), ('Griffin', 584, 2, 5, 2, 3, 5, ''), ('slasher', 585, 4, 4, 2, 3, 0, ''), ('Probe', 586, 3, 4, 3, 3, 5, ''), ('Rifter', 587, 4, 3, 3, 3, 0, ''), ('Executioner', 589, 4, 3, 3, 3, 0, ''), ('Inquisitor', 590, 3, 2, 4, 3, 5, ''), ('Tormentor', 591, 3, 3, 4, 3, 5, ''), ('Navitas', 592, 3, 3, 3, 3, 5, ''), ('Tristan', 593, 3, 3, 3, 3, 5, ''), ('Incursus', 594, 3, 3, 4, 3, 5, ''), ('Punisher', 597, 4, 2, 4, 3, 0, ''), ('Breacher', 598, 3, 4, 3, 3, 5, ''), ('Burst', 599, 3, 3, 3, 3, 5, ''), ('Kestrel', 602, 4, 4, 2, 3, 0, ''), ('Merlin', 603, 3, 4, 3, 3, 0, ''), ('Heron', 605, 3, 5, 2, 3, 5, ''), ('Imicus', 607, 3, 4, 3, 3, 5, ''), ('Atron', 608, 4, 3, 3, 3, 0, ''), ('Maulus', 609, 2, 4, 3, 3, 5, ''), ('Crucifier', 2161, 2, 4, 3, 3, 5, ''), ('Echelon', 3532, 0, 1, 0, 0, 0, ''), ('Vigil', 3766,[...] MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 293 http://pastebin.com/LxKBF7CG Anyone see what is wrong with it? Quote Link to comment https://forums.phpfreaks.com/topic/276304-syntax-error-help/ Share on other sites More sharing options...
Solution Jessica Posted March 29, 2013 Solution Share Posted March 29, 2013 Probably the last line where you have a comma and nothing after it.q Quote Link to comment https://forums.phpfreaks.com/topic/276304-syntax-error-help/#findComment-1421874 Share on other sites More sharing options...
Th3Boss Posted March 29, 2013 Author Share Posted March 29, 2013 Probably the last line where you have a comma and nothing after it.q Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/276304-syntax-error-help/#findComment-1421878 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.