Skip to content

Instantly share code, notes, and snippets.

@joparara
Created April 17, 2024 03:50
Show Gist options
  • Save joparara/d06763a52968e4f9cc47eca195afb459 to your computer and use it in GitHub Desktop.
Save joparara/d06763a52968e4f9cc47eca195afb459 to your computer and use it in GitHub Desktop.
how to concat sql

Concat to column new data (append) (instead of getting the data then appending to it)

UPDATE `table_name` SET <column>=concat(<column>, 'newData')

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment