#1054 - Unknown column

mysql sql varchar sqldatatypes mysql-error-1054
Zain Ali picture Zain Ali · Oct 24, 2012 · Viewed 22.5k times · Source

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'

Answer

Blaise Swanwick picture Blaise Swanwick · Oct 24, 2012

You must surround any strings with quotes.

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

Related questions

How to convert Varchar to Double in sql?

I have problem with my query when I was trying to convert the varchar field to double (numeric). I have this sql statement: SELECT fullName, CAST(totalBal as numeric(9,2) FROM client_info ORDER BY totalBal DESC Actually I want to …

Read More
Can I use VARCHAR as the PRIMARY KEY?

I have a table for storing coupons/discounts, and I want to use the coupon_code column as the primary key, which is a VARCHAR. My rationale is that, each coupon will have a unique code, and the only commands …

Read More
MySQL - Select only numeric values from varchar column

Consider the following table : create table mixedvalues (value varchar(50)); insert into mixedvalues values ('100'), ('ABC100'), ('200'), ('ABC200'), ('300'), ('ABC300'), ('400'), ('ABC400'), ('500'), ('ABC500'); How can I write a select statement …

Read More