'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.

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".

Related Tags for MySQL Append Data:

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