MySQL Append Data

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

'CONCAT()' function is used to append data to the column value. In this example, we are concatenating the value 'sandeep' and the "studentid" column for each row of the "mca" table.

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

Table: "mca"

Query to concatenate value "sandeep" to the column values:

Query

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

Output

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

You can see above, every value of "studentid" column is appended by "sandeep".

MySQL Append Data

MySQL Append Data

MySQL Append Data

Tutorials