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) Quote 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. Quote 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 :) Quote Link to comment https://forums.phpfreaks.com/topic/8499-query-problem/#findComment-31105 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.