<p class="intro">tt_news 表的uid 和 tt_news_hidden 表的number 是相等的话,那么把deleted 设置成1</p> <table width="620" align="center" border="0" cellpadding="1" cellspacing="1" style="background:#FB7"> <tr> <td width="464" height="27" bgcolor="#FFE7CE"> 代码如下</td> <td width="109" align="center" bgcolor="#FFE7CE" style="cursor:pointer;" onclick="doCopy('copy8930')">复制代码</td> </tr> <tr> <td height="auto" colspan="2" valign="top" bgcolor="#FFFFFF" style="padding:10px;" class="copyclass" id="copy8930">update `tt_news` inner join tt_news_hidden set deleted = 1 where uid = number</td> </tr> </table>