Phoenix.pm: mySQL question

Scott Walters root at nebuchadnezzar.slowass.net
Sun May 21 00:21:02 CDT 2000


> UPDATE icm_priv, icm_groups
> SET    icm_priv.priv=5
> WHERE  icm_priv.gid IN (
>   SELECT icm_priv.gid 
>   FROM   icm_priv, icm_groups
>   WHERE icm_priv.gid=icm_groups.gid
>   AND   icm_priv.uid=icm_groups.owner);

Oooops, more sloppy replying from me leads to misinformation!
should be 'UPDATE icm_priv' only.

-s




More information about the Phoenix-pm mailing list