Answer / 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');

What is mysql workbench used for?

0 Answers  

---

Is mysql server free?

0 Answers  

---

what is the difrence between sql and pl/sql

21 Answers   Wipro,

---

How to represent ENUMs and SETs internally?

0 Answers  

---

The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?

4 Answers   Afixi, GE,

---

How to delete the repeated records from a table?

0 Answers  

---

What are the different table present in MYsql?

3 Answers  

---

What are procedures in mysql? Explain

0 Answers  

---

What is “i_am_a_dump” flag in mysql?

0 Answers  

---

Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters

3 Answers  

---

Why do we write stored procedures?

0 Answers  

---

What are the method you will follow while sql installing

0 Answers   Mind Tree,

---