报什么错呢?try... ====================== UPDATE cdb_threads t ,cdb_posts p SET t.closed =1 WHERE p.message LIKE '%dddd%' && p.tid = t.tid
升级的语句:UPDATE cdb_threads t JOIN cdb_posts p ON p.tid = t.tid SET t.status=1 WHERE p.message LIKE '%dddd%'升级错误,MySQL 提示: Unknown column 't.status' in 'field list' ,请返回。
======================
UPDATE cdb_threads t ,cdb_posts p SET t.closed =1 WHERE p.message LIKE '%dddd%' &&
p.tid = t.tid