List:General Discussion« Previous MessageNext Message »
From:Won Lee Date:June 19 2002 8:01pm
Subject:Re: multiple updates
View as plain text  
It works.  I put in an extra comma before the WHERE statement.


At 02:35 PM 6/19/2002 -0500, you wrote:
>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