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

What is schema in mysql?

0 Answers  

---

SQL: 1. Write a queryto retrieve the author who was published a book at the youngest age? 2. write a query to retrieve the no. of books published a each year in various languages? 3. write a query to retrieve no. of books published by them only those authors who have published more than 1 book? 4. write a query to retrieve who has not published any books during the year 2006? 5. write a query to retrieve the authors who has published any books during the birth date write this query in 2 ways 1)joins 2)sub query 6. write a query to retrieve all the books which was published during jan 2007 & title containing India or published in the language hindi? 1. table name is liberary managemnt and two column is there one is authors and another one is books . 2.four fields will comes under authours like nationality, birthdate ,first-language,second-language 3.four fields will comes under books like authour,title ,language,publish date to write query using this details

4 Answers   Covansys,

---

What is difference between group by and order by clause?

0 Answers  

---

can you elaborate on blob and text in mysql? : Mysql dba

0 Answers  

---

How Switch (select or use) to a database.

0 Answers  

---

Why do we use mysql?

0 Answers  

---

Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?

1 Answers   TCS,

---

I want to make a query where I want to eliminate the duplicate rows from the table. For example : Input : Table : NAME Column1 Column2 India USA USA India UK India India UK The desired output that I want to eliminate the duplicates Output India USA UK India Thanks

2 Answers   Sun Life,

---

What are the advantages of MySQL when compared with Oracle?

0 Answers  

---

How to display top 50 rows?

0 Answers  

---

What are the three types of queries?

0 Answers  

---

What are date and time functions in mysql?

0 Answers  

---