Rich, >Hi >does anyone know of a way of taking some data from one table and updating >another table with it? >If MySQL doesn't support it i'm gonna have to go back to Access or something! >thanks > >Rich
Sinisa is right now writing a multi-table update to 4.0. Some updates can be handled already in 3.23 with REPLACE INTO ... SELECT ... Regards, Heikki http://www.innodb.com --------------------------------------------------------------------- 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
