Table: immunization
id vac_id vaccine_id
1 5 0
2 5 0
3 3 0
4 4 0
5 4 0
Table: vaccine
id vac_id
8 1
9 2
10 3
11 4
12 5
我有两个表,现在我想通过匹配vaccine.vac_id=immunization.vac_id将疫苗表的id设置为免疫表的vaccine_id
为此,我使用了类似于butgetingerror1064的查询
UPDATE immunization
SET immunization.vaccine_id = vaccine.id
FROM vaccine,immunization
WHERE vaccine.vac_id = immunization.vac_id
最佳答案
UPDATE immunization i
join vaccine v
on i.vac_id=v.vac_id
SET i.vaccine_id = v.id
集到最后
关于mysql - 错误代码:MySQL更新查询中出现1064,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/32263811/