How to update mysql table fields with join ?07.12.13

update Table1 t1 join Table2 t2 on t1.ID=t2.t1ID join Table3 t3 on t2.ID=t3.t2ID set t1.Value=12345 where t3.ID=54321 example: update products_description t1 join products t2 on t1.products_id=t2.products_id join products_to_categories t3 on t1.products_id=t3.products_id join categories_description t4 on t3.categories_id=t4.categories_id set t1.products_url=t4.categories_name; 07.12.13

http://dev.mysql.com/doc/refman/4.1/en/update.html

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024