Concat in mysql, by using this function we can join two or more than two string values..
mysql>SELECT concat("scott","smith");
SELECT concat(trim("scott"),"smith");
SELECT concat(uname,db) FROM tablename;
output :
concat(uname,db)
rootmysql
roottest
mysql>SELECT concat("scott","smith");
SELECT concat(trim("scott"),"smith");
SELECT concat(uname,db) FROM tablename;
output :
concat(uname,db)
rootmysql
roottest
0 comments:
Post a Comment