//将article表的日期转为news表的时间戳 UPDATE `news` SET pubdate = (SELECT UNIX_TIMESTAMP(updatetime) FROM `article` where`article`.id = `news`.id)
//将article表的时间戳转为news表的日期 UPDATE `news` SET pubdate = (SELECT FROM_UNIXTIME(updatetime) FROM `article` where`article`.id = `news`.id)