Hi Scott,
> at line 3INSERT INTO clf_cities SET cityname = 'Santa Barbara', countryid
> = , enabled = '1'
The error is because you havent specified the value for the column
"countryid". If you do not want to insert the value to the column
"countryid" then use the following query.. do not leave the value of column
blank.
INSERT INTO clf_cities SET cityname = 'Santa Barbara', countryid =NULL ,
enabled = '1'
Thanks,
ViSolve DB Team
----- Original Message -----
From: "Scott Yamahata" <scott_yamahata@stripped>
To: <mysql@stripped>
Sent: Friday, December 29, 2006 11:59 AM
Subject: SQL syntax
> 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
>
> _________________________________________________________________
> Experience the magic of the holidays. Talk to Santa on Messenger.
>
> http://clk.atdmt.com/MSN/go/msnnkwme0080000001msn/direct/01/?href=http://imagine-windowslive.com/minisites/santabot/default.aspx?locale=en-us
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.409 / Virus Database: 268.15.29/607 - Release Date:
> 12/28/2006
>
>
