List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:June 19 2002 7:35pm
Subject:Re: multiple updates
View as plain text  
In the last episode (Jun 19), Won Lee said:
> Hi everyone,
> 
> I'm slowly starting to learn the nuances of MySQL.  I searched the
> HTML docs on mysql.com but the subject matter is so broad that I'm
> flooded with possible matches.  I read through some of the docs but I
> still don't have a solution.
> 
> 
>       UPDATE RFSMs
>       SET
>            approved = 1,
>       WHERE RFSMID IN (#variables.approvedID#)
> 
> While this should works in MSSQL Server, I haven't tested it out yet,
> I know it won't work in mySQL.

That should work, assuming "#variables.approvedID#" is with a single
integer, or a list of comma-dalimited ones.  What mysql does not
support is WHERE .. IN ( SELECT ... )  - i.e. subselects.

-- 
	Dan Nelson
	dnelson@stripped
Thread
multiple updatesWon Lee19 Jun
  • Re: multiple updatesDan Nelson19 Jun
    • Re: multiple updatesWon Lee19 Jun