How can we change the name of a column of a table?

7 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,

---

What is memory table in mysql?

0 Answers  

---

What is difference between inner vs self vs cross?

0 Answers  

---

How do you select a table?

0 Answers  

---

How to control the max size of a heap table?

0 Answers  

---

how many fields can be updated using set in a mysql query?

1 Answers  

---

How do I install mysql?

0 Answers  

---

What are CSV tables?

1 Answers  

---

what if you really want to store the timestamp data, such as the publication date of the article?

2 Answers  

---

How do I run mysql without installing?

0 Answers  

---

What are features of mysql?

0 Answers  

---