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.

-1 We're programmers too, not magicians. It is impossible to tell what the problem could be just based on that SQL. We need to see the table design, and a sample record would be helpful too. — Josh Stodola
– Josh Stodola, Commented Mar 11, 2010 at 14:39
Please post the structure for that table. Are you missing a field? — thetaiko
– thetaiko, Commented Mar 11, 2010 at 14:42

Daniel Vassallo · Accepted Answer · 2010-03-11 14:42:17Z

6

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

edited Mar 11, 2010 at 14:42

answered Mar 11, 2010 at 14:36

Daniel Vassallo

346k72 gold badges513 silver badges447 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user273551 Over a year ago

when i run at sql..the error become near 'usage VALUES('16','143','ew','weff','25-3-2010','8.00 AM','22-3-2010','10.00 AM'' i dont know to solve it...i 've compare to the other code...but it look similar...

Rob Over a year ago

wrap the table name in backticks, not quotes. INSERT INTO usage (not 'usage')

user273551 Over a year ago

ok..it almost done..it the new error occurs Column count doesn't match value count at row 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 what is the coloums count?

user273551 Over a year ago

thanks daniel...the error because there where 'status' field in the table...is it possible if i want to insert data into table with 1 field without data..

p.marino · Accepted Answer · 2010-03-11 14:48:27Z

0

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

answered Mar 11, 2010 at 14:48

p.marino

6,2823 gold badges27 silver badges37 bronze badges

1 Comment

user273551 Over a year ago

i also think like that...but i've 2time retyping it...and really2 mess with this...

Collectives™ on Stack Overflow

INSERT INTO error in MySQL

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related