-mingyan,ago 两表联合查询 select * from mingyan a, ago b where a.name=b.name -条件查询创建新表 ago_new select a.id,a.name,a.content into ago_new from mingyan a, ago b where a.name=b.name update morden_new set [time]='近'