Help me on Mysql

[jcmiras]

I have this code,

INSERT INTO `newbus` ( 'busid' )
VALUES (
'3'
)

And i got this error message,
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 ''busid' ) VALUES (
'3'
)' at line 1

What seems to be the problem? Thanks

[arran]

Try it without using quotes for table/column names:

INSERT INTO newbus (busid) VALUES ('3');

If busid is a numeric column, also remove the quotes from '3':

INSERT INTO newbus (busid) VALUES (3);

[grnidone]

Have you tried to put a ; (semicolon) at thee end of the statement?

The way you do the statement (the pattern) is like this:

Insert into table_name
(columnName1, ColumnName2, ...)
Values (Value1, Value2, ...);

[Birdman]

Your column names don't need to be quoted. If you want/need to quote the column names, use the back tick(`) instead.

INSERT INTO `newbus` ( busid )
VALUES (
'3'
)

or

INSERT INTO `newbus` ( `busid` )
VALUES (
'3'
)

Cheers

[jcmiras]

Thanks, now i know my mistake. My eyes are not realy good in differentiating ( ' ) and ( ` ).