SQL syntax - Scott Yamahata - com.mysql.lists.mysql

10 messages in com.mysql.lists.mysqlSQL syntax

From	Sent On	Attachments
Ashley M. Kirchner	28 Dec 2006 10:20
Chris White	28 Dec 2006 10:34
Ashley M. Kirchner	28 Dec 2006 10:43
Dan Nelson	28 Dec 2006 10:52
Ashley M. Kirchner	28 Dec 2006 11:47
Scott Yamahata	28 Dec 2006 22:29
ViSolve DB Team	28 Dec 2006 22:56
ViSolve DB Team	28 Dec 2006 23:01
Joerg Bruehe	29 Dec 2006 02:17
Rhino	31 Dec 2006 14:35

Subject:	SQL syntax
From:	Scott Yamahata (scot...@hotmail.com)
Date:	12/28/2006 10:29:08 PM
List:	com.mysql.lists.mysql

Hi, I'm getting the following error message:

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 ' enabled = '1'' at line 3INSERT INTO clf_cities SET cityname = 'Santa Barbara', countryid = , enabled = '1'

and can't quite figure out what it means. Any help is greatly appreciated.

Thanks,

Scott