use `testdb`; update dtable d INNER JOIN new_table n ON d.details = n.details
set d.email = n.email, d.cellphone =n.cellphone,d.contact = n.contact,d.address = n.address
update 遇到 disable safe
使用 以下语句解决
SET SQL_SAFE_UPDATES=0;
use `testdb`; update dtable d INNER JOIN new_table n ON d.details = n.details
set d.email = n.email, d.cellphone =n.cellphone,d.contact = n.contact,d.address = n.address
update 遇到 disable safe
使用 以下语句解决
SET SQL_SAFE_UPDATES=0;