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 many columns can a mysql table have?

900


In which language mysql has been written?

1324


how to connect a php script with the mysql database?

1037


How to copy data from one server to another using php?

1040


What is the command line end user interface - mysql?

1074


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

928


What is mysql command line?

1048


What is a query in mysql?

984


What command is used to delete the data from the table without deleting the table structure?

970


What does mysql flush tables do?

959


What is the difference between char and varchar?

1175


Why do we use preparedstatement?

909


What does mysql_query return?

1023


Where is mysql data stored linux?

1005


Does mysql use sql?

878