帮忙解决!在线等!我想更新3小时之前发表的记录进行更新,下面的语句不对!不执行,高手帮忙改正!conn.execute
帮忙解决!在线等!
我想更新3小时之前发表的记录进行更新,下面的语句不对!不执行,高手帮忙改正!
conn.execute( "update title set ifzd=0 where ifgg=1 and datediff( 'h ',addtime,date()) <=3 ")
[解决办法]
conn.execute( "update title set ifzd=0 where ifgg=1 and datediff(h,addtime,date()) <=3 ")