MySQL combine two columns and add into a new column

by

Create the column:

ALTER TABLE yourtable ADD COLUMN combined VARCHAR(50);

Update the current values:

UPDATE yourtable SET combined = CONCAT(zipcode, ' - ', city, ', ', state);

Update all future values automatically:

CREATE TRIGGER insert_trigger
BEFORE INSERT ON yourtable
FOR EACH ROW
SET new.combined = CONCAT(new.zipcode, ' - ', new.city, ', ', new.state);

CREATE TRIGGER update_trigger
BEFORE UPDATE ON yourtable
FOR EACH ROW
SET new.combined = CONCAT(new.zipcode, ' - ', new.city, ', ', new.state);

More Related Contents:

  1. how to delete data from table A besides the customer service and director data in table B?
  2. SQL split values to multiple rows
  3. Get records with max value for each group of grouped SQL results
  4. How to populate a table with a range of dates?
  5. MYSQL OR vs IN performance
  6. SELECTING with multiple WHERE conditions on same column
  7. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  8. How to find gaps in sequential numbering in mysql?
  9. MySQL: Invalid use of group function
  10. Convert timestamp to date in MySQL query
  11. Update a column value, replacing part of a string
  12. MySQL: View with Subquery in the FROM Clause Limitation
  13. MySql export schema without data
  14. mysql dynamic query in stored procedure
  15. OUTPUT Clause in MySQL
  16. Using ORDER BY and GROUP BY together
  17. Sorting by date & time in descending order?
  18. MySQL Pivot Table Column Data as Rows
  19. updating columns with a sequence number mysql
  20. MySQL, Concatenate two columns
  21. Select a column with a keyword name
  22. MySQL Stored Procedures not working with SELECT (basic question)
  23. ERROR 1148: The used command is not allowed with this MySQL version
  24. Use Composite Primary Key as Foreign Key
  25. How to select data where a field has a min value in MySQL?
  26. How to SELECT by MAX(date)?
  27. get a recursive parent list
  28. MySQL OPTIMIZE all tables?
  29. Strip last two characters of a column in MySQL
  30. Deleting a row based on the max value

Leave a Comment