CODEWITHSUNDEEP
mysqlsqlvarcharsqldatatypesmysql-error-1054
Zain Ali
Zain Ali

Reputation: 31

#1054 - Unknown column

I am using MySQL 5.5 and phpmyadmin 3.5.2 (provided by http://www.freewebhostingarea.com)

My sql query is:

INSERT INTO `example`(`id`, `name`, `password`) VALUES (1,we,5)

where id is int type, name and password are varchar.

but when ever inserting any value other than integer in name and age,it displays #1054 error, i.e 

#1054 - Unknown column 'we' in 'field list'

Upvotes: 2

Views: 25483

Answers (2)

Robert
Robert

Reputation: 25753

You have to add '' for we and probably for password:

INSERT INTO `example`(`id`, `name`, `password`) VALUES (1,'we','5')

because both values are char type.

Upvotes: 4

Blaise Swanwick
Blaise Swanwick

Reputation: 1755

You must surround any strings with quotes.

INSERT INTO `example`(`id`, `name`, `password`) 
VALUES               (1,'User Name','Password123')

Upvotes: 6

Related Questions