Skip navigation links

MySQL Forums :: Newbie :: SQL Syntax error!


Advanced Search

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! Igor Almeida 01/27/2011 12:21PM
Re: SQL Syntax error! laptop alias 01/27/2011 12:28PM
Re: SQL Syntax error! Igor Almeida 01/27/2011 12:37PM
Re: SQL Syntax error! siti nuraini abd kadir 01/30/2011 08:58PM
Re: SQL Syntax error! Peter Brawley 01/30/2011 09:07PM
Re: SQL Syntax error! siti nuraini abd kadir 01/30/2011 09:25PM


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.