摘要：update table set web58_tree_id = CONCAT(SUBSTR(tree_id, 3, 0),"001",SUBSTR(tree_id, 4)) where tree_id like '003001%' and web58_tree_id is null and id>1218 阅读全文

摘要：update table c1,table c2 set c1.field1 = c2.field1,c1.field1_tree_id = c2.field1_tree_id where c1.name=c2.name and c1.province_id =c2.province_id 阅读全文