malbolgia Posted April 26, 2006 Share Posted April 26, 2006 im trying this queryINSERT INTO character (charname, charborn, charqual, id) VALUES ('Snoopy', '2006-10-08', 'cool', 'Snoopy');and i get this error 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 'character (charname, charborn, charqual, id) VALUES ('Snoopy', 'i cant seem to see whats wrongthis is the table structureid varchar(50) charname varchar(60) charborn date charqual varchar(60) Link to comment https://forums.phpfreaks.com/topic/8499-query-problem/ Share on other sites More sharing options...
AndyB Posted April 26, 2006 Share Posted April 26, 2006 [a href=\"http://htmlite.com/mysql002a.php\" target=\"_blank\"]http://htmlite.com/mysql002a.php[/a] - CHARACTER is a MySQL reserved word and I bet you can't use reserved words for table names. Change the table name to something else and see. Link to comment https://forums.phpfreaks.com/topic/8499-query-problem/#findComment-31101 Share on other sites More sharing options...
malbolgia Posted April 26, 2006 Author Share Posted April 26, 2006 thanks didnt know it was a reserved word :) Link to comment https://forums.phpfreaks.com/topic/8499-query-problem/#findComment-31105 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.