MYSQL---多表更新 person(id,name,job,age) job(id,name) UPDATE person INNER JOIN job ON person.job=job.name SET person.job=job.id;