update page_aggregation_classify p,(SELECT id,title FROM channel WHERE `level` =1 AND deleted =0 )c SET p.channel_id = c.id
WHERE p.`name` LIKE CONCAT(c.`title`,"%")
兩張表A B A新增一個字段想對應B表的字段值 做對應關系 , 感覺挺實用的先備份 以便日後想起來的檢視!
update page_aggregation_classify p,(SELECT id,title FROM channel WHERE `level` =1 AND deleted =0 )c SET p.channel_id = c.id
WHERE p.`name` LIKE CONCAT(c.`title`,"%")
兩張表A B A新增一個字段想對應B表的字段值 做對應關系 , 感覺挺實用的先備份 以便日後想起來的檢視!