> > what i want is: > > UPDATE users SET userinfo_set=1 where (users.userid=userinfo.userid); > > aka, i want to set a flag in every row in users if there is a row > in userinfo with the same userid. > > i've been SELECT INTO OUTFILEing (with a join on the two tables) > and LOAD DATA INFILEing to deal with this. is there a better way? > > thanks! >
There will be! Version 4.1 should have multi-table updates. Steve Meyers --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php