试试看UPDATE `tablename` t1,`tablename` t2 SET t1.order_id=t2.order_id WHERE (t1.id=1 OR t1.id=2) AND (t2.id=1 OR t2.id=2) AND t1.id<>t2.id
id order_id 0 2 1 1 2 3 是这样?
大牛,来个注释好吗,SET t1.order_id=t2.order_id t1.order是我字段的值么?比如说, SET 8=9
UPDATE ttg a INNER JOIN ( SELECT *,(SELECT `order_id` FROM ttg WHERE id=IF(a.id=0,1,0)) AS newid FROM ttg a) c ON a.`id`=c.id SET a.`order_id`=c.newid WHERE a.`id` IN(0,1);
SET t1.order_id=t2.order_id
WHERE (t1.id=1 OR t1.id=2) AND (t2.id=1 OR t2.id=2) AND t1.id<>t2.id
0 2
1 1
2 3
是这样?
t1.order是我字段的值么?比如说,
SET 8=9
SELECT *,(SELECT `order_id` FROM ttg WHERE id=IF(a.id=0,1,0)) AS newid FROM ttg a) c
ON a.`id`=c.id
SET a.`order_id`=c.newid WHERE a.`id` IN(0,1);
我错了,我不要专业的,我就要一段sql能执行就可以,
五星大牛,给注释行不!
算了,数据库我只会普通的curd,存储过程不是很懂,不这样写,我需要写2-4段代码。
多谢各位!