MySQL CONCAT() Function
To concatenate two columns in SQL, you can use the CONCAT function. The syntax is as follows:
SELECT CONCAT(column1, column2) AS new_column_name FROM table_name;
In the above syntax, column1 and column2 are the names of the columns you want to concatenate, new_column_name is the name of the new column that will contain the concatenated result, and table_name is the name of the table containing the columns.
For example, if you have a table named employees with columns first_name and last_name, you can concatenate them into a new column called full_name like this:
SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM employees;
This will create a new column called full_name that contains the concatenated values of first_name and last_name, separated by a space.
Note that the CONCAT function can be used to concatenate more than two columns by simply adding additional column names as arguments.
