The Easiest Way to Save and Share Code Snippets on the web

Copy records to another table and join two columns at the same time

mysql | by: chrisimrie

posted: Jun, 1st 2011 | jump to bottom

INSERT INTO table_name1 SELECT CONCAT_WS(' ', column1, column2) AS column_name3 FROM table_name2;
jump to top
118 views
plaintext | download | copy to clipboard | embed