How do I show columns in mysql?

0 Answers  

---

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

0 Answers  

---

Is mysql frontend or backend?

0 Answers  

---

In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

0 Answers  

---

Why mongodb is faster than mysql?

0 Answers  

---

What is ddl, dml, and dcl?

0 Answers  

---

What is a join? Explain the different types of mysql joins.

1 Answers  

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

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,

---

What are the types of index?

0 Answers  

---

What is relational database in mysql?

0 Answers  

---

Why myisam is faster than innodb?

0 Answers  

---