INSERT INTO error in MySQL

Question

Notice: 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 
'usage VALUES('16','143','ew','weff','25-3-2010','8.00 AM','22-3-2010','10.00 AM''

at line 1 in:

INSERT INTO usage 
VALUES('16'
      ,'143'
      ,'ew'
      ,'weff'
      ,'25-3-2010'
      ,'8.00 AM'
      ,'22-3-2010'
      ,'10.00 AM'
      ,'wfsdc'
      , '34'
      ,' frsdfr '
      ,'TEST 1'
      ,'ISMAIL SALLEH'
      ,'efsdc'
  )

I've no idea where is the error... I'm staring on this for 2 hours, but really cannot find the error.

Answer 1

Try:

INSERT INTO `usage` VALUES ....

You simply need to wrap the table name in backticks, because USAGE is a reserved word in MySQL.

Source: MySQL Docs: Reserved Words

Answer 2

Have you tried retyping it from scratch in case you put the line together using cut and paste and maybe accidentally included an invisible control character which makes the SQL parser choke...?