MySQL Forums
Forum List  »  Newbie

SQL Syntax error!
Posted by: Igor Almeida
Date: January 27, 2011 12:21PM

Hi Guys,
I'm having a stupid error:

Table:
CREATE TABLE `breakfast` (
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`price` text NOT NULL,
`desc` text NOT NULL,
PRIMARY KEY (`id`)
)

String:
INSERT INTO breakfast (name, price, desc ) VALUES ('blah blah blah', '3.45', 'blah blah blah')

Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc ) VALUES ('blah blah blah', '3.45', 'blah blah blah')' at line 1

I have a nother table similar to this one and it works fine under the same connection files! Humpf!

Thank you,
Igor Almeida



Edited 1 time(s). Last edit at 01/27/2011 12:26PM by Igor Almeida.

Options: ReplyQuote


Subject
Written By
Posted
SQL Syntax error!
January 27, 2011 12:21PM
January 27, 2011 12:28PM
January 27, 2011 12:37PM
January 30, 2011 09:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.