Advanced
View Scraps
Categories
Most Viewed
Top Rated
Add Scraps
History
Today in History
Thoughts
Welcome,
Logout
Sign In / Sign Up
Mysql CONCAT function
by Sasikumar
[
Edit
]
2014-05-26 16:22:16
MySQL CONCAT function :
SELECT CONCAT(first_name, " ", last_name) as Name FROM user_details;
Table Structure with Data :
Table name :
user_details
Id
first_name
last_name
1
Sasi
Kumar
2
Mohan
Kumar
3
Guru
Prasath
4
Satheesh
Kumar
Output:
Name
Sasi Kumar
Mohan Kumar
Guru Prasath
Satheesh Kumar
Tagged in:
Mysql
concat
Merge column
CONCAT Mysql Results
1423
0
0
Previous
Next
You must
LOGIN
to add comments
Posting your comment...
Tags
Apache
Firefox Tweeks
Shortcuts
PHP
Others
CSS
Javascript
DNS
Windows
Websites
Linux
Game programming
Mysql
CVS
HTML
MS Office
JSP/Java
FTP Server
Flash
AJAX
More...
Indian Web Directory
Time Zone Converter
Web Internet Statistics
Live Chatting Online
Comments
expected, smart move:)
Already black money holders account is empty..
The money will never return
Nice sharing..
Thank you...
Good one...
Nice post...
Good sharing.....
Good...
Thanks for nice sharing...