Question

MYSQL更新语句

我有一个表grade,字段如下
id

life_a

life_b

life_c

life_grow_a

life_grow_b

life_grow_c

phy_min_a

phy_min_b

phy_min_c

表里两表数据.我要把ID=1的字段数据更新到ID=2
就是我们说的把ID1的数据复到ID2上,不包括ID也复
请问这样的MYSQL语法如何写

Answer 1

用这个吧，肯定可以
update grade set life_a=(select life_a from grade where id=1),
life_a=(select life_a from grade where id=1),
life_b=(select life_b from grade where id=1),
life_c=(select life_c from grade where id=1),
life_grow_a=(select life_grow_a from grade where id=1),
life_grow_b=(select life_grow_b from grade where id=1),
life_grow_c=(select life_grow_c from grade where id=1),
phy_min_a=(select phy_min_a from grade where id=1),
phy_min_b=(select phy_min_b from grade where id=1),
phy_min_c=(select phy_min_c from grade where id=1)
where id=2

Answer 2

这样子可以实现你的要求，楼上的语句应该会报错

UPDATE grade A, grade B
SET A.life_a = B.life_a
A.life_b = B.life_b
A.life_c = B.life_c
A.life_grow_a = B.life_grow_a
A.life_grow_b = B.life_grow_b
A.life_grow_c = B.life_grow_c
A.phy_min_a = B.phy_min_a
A.phy_min_b = B.phy_min_b
A.phy_min_c = B.phy_min_c
WHERE B.id = 1
AND A.id = 2

Answer 3

你可以单mm我，给一点测试数据 你这里说的很不清楚