Appending columns values can be performed using CONCAT() function. By this function, values of columns can be concatenated and made them a single value.

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                           |
+-----------+----------------------------------------------+

Related Tags for MySQL Append Column:

More Tutorials from this section

• MySQL Addition
• MySQL Add Column
• MySQL Aggregate Function
• MySQL Append
• MySql Append Codes
• MySQL Append Column
• MySQL Append Data
• MySQL Append String
• SQL Functions
• Mysql Difference
• Mysql Group By
• Mysql last day of month
• Mysql Last Record
• Mysql last row
• Mysql Last
• Mysql Left Function
• Mysql Left
• Mysql Length Function
• Mysql String Length
• Mysql Like Command