This example illustrates how to append data with a column value.
This example illustrates how to append data with a column value.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 | +-----------+------------------------------+