Skip to main content
AI Assist is now on Stack Overflow. Start a chat to get instant answers from across the network. Sign up to save and share your chats.

Return to Answer

deleted 1 characters in body
Source Link
Bill the Lizard
Bill the Lizard
  • 407.4k
  • 213
  • 579
  • 892

UPDATE table1, table2 SET table1.col1='value', table2.col1='value' WHERE table1.col3='567' AND table2.col6='567'

UPDATE table1, table2 SET table1.col1='value', table2.col1='value' WHERE table1.col3='567' AND table2.col6='567'

This should work for ya.

HereThere is a reference in he MySQL manual -> http://dev.mysql.com/doc/refman/5.0/en/update.htmlthe MySQL manual There is an example for multiple tables.

UPDATE table1, table2 SET table1.col1='value', table2.col1='value' WHERE table1.col3='567' AND table2.col6='567'

This should work for ya.

Here is a reference in he MySQL manual -> http://dev.mysql.com/doc/refman/5.0/en/update.html There is an example for multiple tables.

UPDATE table1, table2 SET table1.col1='value', table2.col1='value' WHERE table1.col3='567' AND table2.col6='567'

This should work for ya.

There is a reference in the MySQL manual for multiple tables.

Source Link
UnkwnTech
UnkwnTech
  • 91.4k
  • 68
  • 192
  • 234

UPDATE table1, table2 SET table1.col1='value', table2.col1='value' WHERE table1.col3='567' AND table2.col6='567'

This should work for ya.

Here is a reference in he MySQL manual -> http://dev.mysql.com/doc/refman/5.0/en/update.html There is an example for multiple tables.