PC Nerd Posted April 9, 2007 Share Posted April 9, 2007 UPDATE queryies: i know that you can select multiple tables with SELECT queryies, but is it possible to update many fields from two tables?? eg UPDATE table1, table2 SET table1.field = '', SET table2.field4 = '' is that posible Link to comment https://forums.phpfreaks.com/topic/46227-solved-udate-sql/ Share on other sites More sharing options...
btherl Posted April 9, 2007 Share Posted April 9, 2007 Mysql has a multiple table syntax listed here: http://dev.mysql.com/doc/refman/5.1/en/update.html Look towards the end for examples. Link to comment https://forums.phpfreaks.com/topic/46227-solved-udate-sql/#findComment-224757 Share on other sites More sharing options...
PC Nerd Posted April 9, 2007 Author Share Posted April 9, 2007 thankyou Link to comment https://forums.phpfreaks.com/topic/46227-solved-udate-sql/#findComment-224759 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.