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/
