mysql主表更附表自动更新语句
来源:动视网
责编:小采
时间:2020-11-09 10:01:06
mysql主表更附表自动更新语句
mysql主表更附表自动更新语句:tt_news 表的uid 和 tt_news_hidden 表的number 是相等的话,那么把deleted 设置成1 代码如下 update `tt_news` inner join tt_news_hidden set deleted = 1 where uid = number
导读mysql主表更附表自动更新语句:tt_news 表的uid 和 tt_news_hidden 表的number 是相等的话,那么把deleted 设置成1 代码如下 update `tt_news` inner join tt_news_hidden set deleted = 1 where uid = number

tt_news 表的uid 和 tt_news_hidden 表的number 是相等的话,那么把deleted 设置成1
代码如下 |
|
update `tt_news` inner join tt_news_hidden set deleted = 1 where uid = number |
mysql主表更附表自动更新语句
mysql主表更附表自动更新语句:tt_news 表的uid 和 tt_news_hidden 表的number 是相等的话,那么把deleted 设置成1 代码如下 update `tt_news` inner join tt_news_hidden set deleted = 1 where uid = number