This example illustrates how to append data with a column value.

MySQL Append Data

This example illustrates how to append data with a column value.

In this example we use 'CONCAT' function to append data to the column value.

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

select studentid, CONCAT(studentid, 'sandeep') FROM mca;

Output

+-----------+------------------------------+
| studentid | CONCAT(studentid, 'sandeep') |
+-----------+------------------------------+
| 3         | 3sandeep                     |
| 2         | 2sandeep                     |
| 1         | 1sandeep                     |
+-----------+------------------------------+

Related Tags for MySQL Append Data: