This is a discussion on Multiple Table Update in MYSQL 3.23 within the MySQL Database forums, part of the Database Forums category; I have this SQL UPDATE MVActors, MVActorsInfo, MVActorsInfotmp SET `ActorID` = `MVActorsInfotmp`.`ID` WHERE `MVActorsInfo`.`ID` = `ActorID` AND `MVActorsInfotmp`.`ActorName` = `MVActorsInfo`.`...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
I have this SQL
UPDATE MVActors, MVActorsInfo, MVActorsInfotmp SET `ActorID` = `MVActorsInfotmp`.`ID` WHERE `MVActorsInfo`.`ID` = `ActorID` AND `MVActorsInfotmp`.`ActorName` = `MVActorsInfo`.`ActorName` AND `MVActorsInfotmp`.`ActorLastName` = `MVActorsInfo`.`ActorLastName` ; which does work under v. 5.0.23 but does not work under v. 3.23 because this version does not support multiple table update. How can i do this work? Thanks, Marios Tofarides |