mysql要实现两列数据互换,适用于多行,例子如下:
UPDATE
`user` AS a,
`user` AS b
SET
`a`.`user_name` = `b`.`pass_word`,
`a`.`pass_word` = `b`.`user_name`
WHERE
`a`.`id` = `b`.`id`;
注意:
必须要存在主键的连接条件!
更多推荐
sql语句实现两列数据互换
UPDATE
`user` AS a,
`user` AS b
SET
`a`.`user_name` = `b`.`pass_word`,
`a`.`pass_word` = `b`.`user_name`
WHERE
`a`.`id` = `b`.`id`;
更多推荐
sql语句实现两列数据互换
发布评论