MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 1 1999 3:26am
Subject:Re: Updating a set
View as plain text  
At 9:30 PM -0500 8/31/99, B B wrote:
>I am currently using mySQL and I am trying to update a set to have 2
>values. I am using this command:
>update table1 set
>languages=('French text','English text')
>where fileID='books';
>though it is not working as the error that I am getting is as follows
>MySQL said: parse error near 'text','English text') where
>fileID='books'' at line 2
>Can you find out what is wrong in this statement

I'm not sure if this is the problem, but SET values are specified
as a *single* string.

...languages='French text,English text'

might be what you want.

Paul DuBois, paul@stripped
Northern League Chronicles:
Updating a setB B1 Sep
  • Re: Updating a setPaul DuBois1 Sep