Using insert into using mysql

Question

I need to insert the following into my table...My users table has five columns id, username, password, name, entry. (im not submitting anything into entry just yet i will use php to do that later on) but for some reason i keep getting this error: #1054 - Unknown column 'const89' in 'field list' Why is it reading the value as a column?

INSERT INTO users  VALUES(1,const89,cdm89,constantin);

I have also tried INSERT INTO users (id,username,password,name) VALUES(1,const89,cdm89,constantin); which gives me the same exact error.

John Conde · Accepted Answer · 2013-01-26 03:01:46Z

2

You need to put your strings in quotes:

INSERT INTO users  VALUES(1,'const89','cdm89','constantin');

answered Jan 26, 2013 at 3:01

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

Comments

lbrendanl · Accepted Answer · 2013-01-26 03:02:37Z

2

Just put quotes around your strings:

INSERT INTO users VALUES(1,'const89','cdm89','constantin');

answered Jan 26, 2013 at 3:02

lbrendanl

2,7044 gold badges36 silver badges55 bronze badges

Comments

Muhammad Hani · Accepted Answer · 2013-01-26 03:02:23Z

1

Put your string values within quotes.

INSERT INTO users  VALUES(1,'const89','cdm89','constantin');

answered Jan 26, 2013 at 3:02

Muhammad Hani

8,6725 gold badges32 silver badges44 bronze badges

1 Comment

Muhammad Hani Over a year ago

@slugonamission - I've edited the answer even before your comment :), you're right, thanks.

Collectives™ on Stack Overflow

Using insert into using mysql

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related