sql - MySQL Join Update -

sql - MySQL Join Update -

a (supposedly) simple update has turned out not simple. no matter syntax seek other answered questions, same response mysql:

0 row(s) affected rows matched: 124 changed: 0 warnings: 0

try 1:

update news_content, news_map set news_content.active='no' news_content.rowid = news_map.newsid , news_map.catid = 170;

try 2:

update news_content left bring together news_map on news_map.newsid = news_content.rowid set news_content.active = 'no' news_map.catid = 170;

try 3:

update news_content nc bring together news_map nm on nm.newsid = nc.rowid , nm.catid = 170 set nc.active = 'no';

what think work?

might silly question news_content.active equal 'no'?

mysql sql join