List:General Discussion« Previous MessageNext Message »
From:ViSolve DB Team Date:December 29 2006 7:02am
Subject:Re: SQL syntax
View as plain text  
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
>
> 

Thread
Filling blanks on SELECTAshley M. Kirchner28 Dec
  • Re: Filling blanks on SELECTChris White28 Dec
    • Re: [MySQL] Re: Filling blanks on SELECTAshley M. Kirchner28 Dec
      • Re: [MySQL] Re: Filling blanks on SELECTDan Nelson28 Dec
        • Re: [MySQL] Re: Filling blanks on SELECTAshley M. Kirchner28 Dec
        • SQL syntaxScott Yamahata29 Dec
          • Re: SQL syntaxViSolve DB Team29 Dec
          • Re: SQL syntaxViSolve DB Team29 Dec
          • Re: SQL syntaxJoerg Bruehe29 Dec
          • Re: SQL syntaxRhino31 Dec