Answer / pandu

Run the below query you can get the Data Base Size in MySQL.

If you run the query which is given below in MySQL Query
Browser then you will get the two columns first will display
the Data Base Name and the second will display the Data Base
Size in MB.

SELECT table_schema "Data Base Name", sum( data_length +
index_length ) / 1024 / 1024 "Data Base Size in MB"
FROM information_schema.TABLES GROUP BY table_schema ;

Answer / ramkumar

1 bytes

Is oracle better than mysql?

0 Answers  

---

How to make a column bigger and delete unique from table.

0 Answers  

---

Can we rename database in mysql?

0 Answers  

---

What is mysql server?

0 Answers  

---

What are the differences between innodb and myisam engines?

0 Answers  

---

How to delete a trigger in mysql?

0 Answers  

---

Is mysql same as mariadb?

0 Answers  

---

What are the types of queries?

0 Answers  

---

Is mysql a distributed database?

0 Answers  

---

What is 'mysqlcheck'?

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 do I find my mysql username and password?

0 Answers  

---