List:General Discussion« Previous MessageNext Message »
From:ViSolve DB Team Date:December 29 2006 6:57am
Subject:Re: SQL syntax
View as plain text  
Hi,

have you checked the 'enabled' field datatype or can you give the query.

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 3 INSERT 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
> 

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