update onethink_document set tags=keywords; update onethink_document as d,onethink_document_article as a set d.oldid=a.oid where d.id=a.id; update onethink_document set id=oldid; SELECT oldid FROM onethink_document GROUP BY oldid HAVING COUNT(oldid) > 1 select a.* from onethink_document a inner join onethink_document_article b on a.id=b.id; select * from onethink_document where not exists (select 1 from onethink_document_article where id=onethink_document.id) select a.* from onethink_document a inner join onethink_document_article b on a.id<>b.id; adminroot text-overflow:ellipsis; white-space: nowrap; display: -webkit-box; -webkit-box-orient: vertical;-webkit-line-clamp: 3; youku-playerBox