MySQL Append Data

Ads
 

MySQL Append Data

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

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

Ads

Ads