输入banner图图片脚本导航/分类

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

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

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