Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Which mysql function is used to concatenate string?

Answer Posted / hrindows@gmail.com

CONCAT() function is used to combine two or more string data. The use of this function is here with an example.
Example: The following SELECT query with CONCAT() function will combine five words, ‘Welcome ‘, ‘to’, ‘SoftwareTestingHelp’,’.’ and ‘com’.

SELECT CONCAT('Welcome ',to ','SoftwareTestingHelp','.',com');

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to show table structure mysql?

936


State the differences between mongodb and mysql.

1081


Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1079


What is difference between oracle and mysql?

887


Is mysql a server or database?

842


What is the size of mysql database?

871


Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

842


What is data directory in mysql?

902


How do I assign a variable in mysql?

934


How do I zip a file in mysql?

924


Which command is used to view the content of the table in mysql?

865


What is memory table?

853


In which language mysql has been written?

1268


What is the purpose of -> in the mysql terminal?

1035


How do I remove a user from mysql?

936