INSERT
INTO
users
SELECT
‘newUsername’
,somecolumn
,someothercolumn
,yetanothercolumn
FROM
users
WHERE
username = ‘oldUsername’

  • By: Andrew Kirkpatrick
  • In: MySQL
  • Under: