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 the difference between the primary and unique key in mysql?

0 Answers  

---

How many tables will create when we create table, what are they?

2 Answers  

---

Write a query to display current date and time?

0 Answers  

---

What is Database?

2 Answers  

---

Write a query to create a database and a table?

0 Answers  

---

What are the differences between a primary key and foreign key?

0 Answers  

---

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

0 Answers  

---

What are slow queries?

0 Answers  

---

What language is used in mysql?

0 Answers  

---

when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field

1 Answers  

---

What is mysqlcommand?

0 Answers  

---

What do you understand by mysql terminal?

0 Answers  

---