mysql主表更附表自动更新语句
程序员文章站
2022-06-01 19:51:41
...
tt_news 表的uid 和 tt_news_hidden 表的number 是相等的话，那么把deleted 设置成1
| 代码如下 | 复制代码 |
| update `tt_news` inner join tt_news_hidden set deleted = 1 where uid = number | |