update `dede_full_search`,`dede_archives` set `dede_full_search`.pubdate=`dede_archives`.pubdate WHERE `dede_full_search`.aid=`dede_archives`.id
billy 备忘录 mysql, sql