query problem

[malbolgia]

im trying this query
INSERT 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 wrong

this is the table structure
id varchar(50)
charname varchar(60)
charborn date
charqual varchar(60)

[AndyB]

[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.

[malbolgia]

thanks didnt know it was a reserved word :)