[RESOLVED] PHP + SQL Server - Entering Data

Hi all,

I have created an SQL Server database table 'admin'.

I Right-Click on the table, then select: Open Table > Query

Then I create SQL(insert into admin values("test", "test2")
I verify the code and it is correct.

However, when I select Run it gives an error message - "Column names are not permitted"

Why is this?

Thanks.

Kevin.

INSERT INTO tbl_name (col1,col2) VALUES(test, test2)

You have to specify the Columns were you want the data (test and test2) to go.

Review this link for more info.

http://dev.mysql.com/doc/refman/5.0/en/insert.html

CREATE TABLE admin (
col1 varchar(10) default NULL,
col2 varchar(10) default NULL
) TYPE=MyISAM;
INSERT into admin values("test", "test2");

Tried both but still get the error message.

Using single-quotes seems to do it!

lets see your new code, and what exactly are you using to insert this data?

php, or a tool like MySql Front?

Have you already setup you database with the Column Names, and if so what are they.