how to insert data into table in MySQL

Question

i created this table

create table courses (
cid int primary key not null,
cname varchar(25) )

and when i tried to insert any thing like that

insert into courses values (1,name)

i have this error

insert into courses values (1,`ahmed`)

Error Code: 1054. Champ 'ahmed' inconnu dans field list 0.000 sec

when i try to add only cid it's ok , i removed the table and created it twice and the same problem

what is the wrong thing here?

insert into courses values (1,'ahmed') : try this

Vegeta
– Vegeta

2015-12-24 11:58:31 +00:00
Commented Dec 24, 2015 at 11:58 — Vegeta
– Vegeta, Commented Dec 24, 2015 at 11:58

gmiley · Accepted Answer · 2015-12-24 11:58:58Z

2

You need to delimit your varchar values with single quotes (').

Try the following instead:

insert into courses values (1,'ahmed');

Numerics can be passed without the single quotes, however any char or varchar derived types need the single quotes. Look up datatypes for SQL for further information.

answered Dec 24, 2015 at 11:58

gmiley

6,6041 gold badge15 silver badges25 bronze badges

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

1 Comment

gmiley Over a year ago

Try changing your statement, you are using the back-tick ` instead of a single quote ', copy the statement directly from my answer and try executing it. I believe mysql uses back-tick to delimit objects ( tables, columns, etc...) single quotes are used to delimit values.

Saharsh Shah · Accepted Answer · 2015-12-24 11:59:49Z

1

Put Single quote (') for string values

Try this:

INSERT INTO courses (cid, cname)
VALUES (1, 'ahmed');

answered Dec 24, 2015 at 11:59

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

Collectives™ on Stack Overflow

how to insert data into table in MySQL

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related