Skip to content

Instantly share code, notes, and snippets.

@OBaddeley

OBaddeley/concat columns in table in db using sql

Last active October 30, 2019 00:31
Show Gist options
  • Save OBaddeley/7eb8877cb5dfca63fc3f to your computer and use it in GitHub Desktop.
Save OBaddeley/7eb8877cb5dfca63fc3f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
concat columns in table in db using sql
SELECT concat(first_name, '', last_name) AS Name FROM Students
SELECT * FROM students
ALTER TABLE Students
DROP COLUMN last_name
ALTER TABLE Students
DROP COLUMN first_name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment