---批量异构数据导入INSERT INTO Table1(`catid`, `status`, `inputtime`, `updatetime`)SELECT `typeid`, 99, unix_timestamp(time), unix_timestamp(time)FROM Table2 ----批量数据替换UPDATE `Table1` SET url=REPLACE(url,"/uacool/","/"); ---字符串连接UPDATE `Table1` SET `id`=CONCAT('c-1-',`id`)