Create a gist now

Instantly share code, notes, and snippets.

UPDATE `user` SET `msn` = (
SELECT `password` FROM (
SELECT `userid`, `password` FROM `user` WHERE `userid` = 1
) AS `x`
WHERE userid = 1
)
WHERE userid = xxxx
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment