Home Sql Sql-functions MySQL Append Data
Questions:Ask|Latest

 
 

Share on Google+Share on Google+

MySQL Append Data

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

Advertisement

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: October 6, 2010

Related Tutorials

Ask Questions?    Discuss: MySQL Append Data  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
hanan
March 6, 2012
database connectivity

i want have database connection with GUI application in netbeans.i need your help.
DMCA.com