MySQL Append Column
This example illustrates how to append two column values of a table.
Appending columns values can be performed using CONCAT() function. By this function, values of columns can be concatenated and made them a single value. In this example, we are concatenating the value of "studentid", "sectionid", "courseid", "time" columns for each row of the "mca" table.
Table: "mca"
Table
+-----------+-----------+----------+----------------------------------+ | studentid | sectionid | courseid | time | +-----------+-----------+----------+----------------------------------+ | 3 | 3 | 3 | Mon 14:30-16:00 | | 2 | 2 | 5 | Mon 11:30-12:00, Thu 09:00-11:00 | | 1 | 1 | 6 | Mon 09:30-11:00 | +-----------+-----------+----------+----------------------------------+
Query to concatenate column values:
Query
select studentid, CONCAT(studentid, sectionid, courseid, time) FROM mca;
Output
+-----------+----------------------------------------------+ | studentid | CONCAT(studentid, sectionid, courseid, time) | +-----------+----------------------------------------------+ | 3 | 333Mon 14:30-16:00 | | 2 | 225Mon 11:30-12:00, Thu 09:00-11:00 | | 1 | 116Mon 09:30-11:00 | +-----------+----------------------------------------------+