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" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
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/[EMAIL PROTECTED]
--
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
