Unknown Column

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Unknown Column

Postby bogasrikanth » 26. November 2008 07:43

Hi Friends,

Please help me out with this issue:

From a web page I am trying to insert a row with the following query.

QUERY:
=====
insert into Suppliers values ( 5, `University`, `Carter`, `Stephen`, 1234567890);

But, I get the error

ERROR:
=====
Unknown column 'University' in 'field list'

I was pulling my hair from a long time, but could not find the fix for this.

Thank you in advance.

srikanth
bogasrikanth
 
Posts: 18
Joined: 13. August 2008 19:02

Postby Nobbie » 26. November 2008 11:33

>insert into Suppliers values ( 5, `University`, `Carter`, `Stephen`, 1234567890);


You are using the wrong quotes, you must use either single quotes (') or double quotes ("), but not the so called backticks (`):

insert into Suppliers values ( 5, 'University', 'Carter', 'Stephen', 1234567890);
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 17 guests