Sql Insert Error

[zink]

Hi all

Having a major problem with this very simple SQL INSERT. Getting the classic error but just can't work out why I'm getting it.

INSERT INTO return VALUES('','274','Via','Shepton Mallet','fghgfg','45','test','test','1')

Produces 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 'return VALUES('','274','Via','Shepton Mallet','fghgfg','45','test','t' at line 1

I am not a beginner by any means and have had this error many times before but the usual fix is not the problem.

Errr WTF, please help

[swampBoogie]

return is a reserved word in SQL. Either rename the table or enclose it in `` i.e.

`return`

[zink]

LOL of course it is

I knew it was something obvious like that!

thanks for your help swamp