List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:May 14 2002 3:20am
Subject:Re: New To List
View as plain text  
At 15:55 +0100 5/10/02, Ewen Marshall wrote:
>Hi everyone...
>I'm new to MySQL and new to this list.....
>I've just installed mysql-max-3.23.49 on 2000, which went very well :)
>I had a few problems hooking Perl into it, but I've now got that resolved
>too...wohoo...anyway, I'm having problems with UPDATE...when I execute:
>UPDATE contacts SET name = "$name" WHERE  name = "$name" AND phone = 
>"$phone" AND mobile = "$mobile";
>it works fine. But I can't update more than one value at a time. I 
>want to update all three columns
>(name, phone and mobile) at once. How do I do this?

The SET clause can consist of multiple col_name = value pairs; just
separate them by commas.

By the way, you do know that your statement shown above does nothing,

>Thanks in advance,
>	Ewen

New To ListEwen Marshall10 May
  • Re: New To ListJames Treworgy10 May
  • Re: New To ListGelu Gogancea10 May
  • Re: New To ListTerence11 May
  • Re: New To ListPaul DuBois14 May