mysql主表更附表自动更新语句
- WBOYOriginal
- 2016-06-07 17:48:291299browse
tt_news 表的uid 和 tt_news_hidden 表的number 是相等的话，那么把deleted 设置成1
| 代码如下 | 复制代码 |
| update `tt_news` inner join tt_news_hidden set deleted = 1 where uid = number | |
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：常用的SQL日期时间函数Next article：sql 数据表存在就删除不存在就创建