mysql主表更附表自动更新语句

tt_news 表的uid 和 tt_news_hidden 表的number 是相等的话，那么把deleted 设置成1

代码如下	复制代码
update `tt_news` inner join tt_news_hidden set deleted = 1 where uid = number