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

Is mysql free for commercial use?

924


How to update info already in a table and delete a row(s) from a table.

859


How to dump a table to a file with 'mysqldump'?

1034


What is normalization and list the different types of normalization?

951


How to get the number of rows selected or affected by a sql statement?

919


Is mysql workbench a dbms?

1007


Is pdo more secure than mysqli?

882


How to declare variable in mysql trigger?

1012


What is indexing in mysql?

965


What is mysqlcommand?

1002


What is mysql gpl?

859


What is MySQL?

1000


What is mysql data directory? How to determine the location of the data directory?

937


What is mysqli_select_db?

967


Why we use mysqli instead of mysql?

1089