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: http://www.snake.net/nl/
Thread
Updating a setB B1 Sep
  • Re: Updating a setPaul DuBois1 Sep