Databases| SQL| MySQL| Questions?

 

 

 

 

 

 

 

 

 

 

 

 

 

Search Tutorials
Latest Questions
Comments
 
 
 


 

MySQL Append Column

                         

This example illustrates how to append two column values of a table.

Appending columns values can be performed using CONCAT() function. By this function, values of columns can be concatenated and made them a single value. In this example, we are concatenating  the value of "studentid", "sectionid", "courseid", "time" columns for each row of the "mca" table.

Table: "mca"

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 to concatenate column values:

Query

 

 
select studentid, CONCAT(studentid, sectionid, courseid, time) FROM mca;

 

 
Output

 

 
+-----------+----------------------------------------------+
| studentid | CONCAT(studentid, sectionid, courseid, time) |
+-----------+----------------------------------------------+
| 3         | 333Mon 14:30-16:00                           |
| 2         | 225Mon 11:30-12:00, Thu 09:00-11:00          |
| 1         | 116Mon 09:30-11:00                           |
+-----------+----------------------------------------------+

 

                         

» View all related tutorials
Related Tags: sql mysql c query table ant value return tab record to ini e use ul im from in m nt

Leave your comment:

Name:

Email:

URL:

Title:

Comments:

Enter Code:
Audio Version
Reload Image
 

Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted.

No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.
Add This Tutorial To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Training Courses
Tell A Friend
Your Friend Name
Software Solutions
Least Viewed
Most Rated
Recently Viewed
Search Tutorials

 

 
 

Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Search Engine | News Archive | Jboss 3.0 tutorial | Free Linux CD's | Forum | Blogs

About Us | Advertising On RoseIndia.net  | Site Map

India News

Indian Software Development Company | iPhone Development Company in India | Flex Development Company in India | Java Training Delhi | Java Training at Noida |

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2008. All rights reserved.