OBaddeley
4/29/2015 - 12:21 AM
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_nameSELECT 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