Answer Posted / a.kishan kumar
mysql> select
table_schema,sum(data_length+index_length)/1024/1024 from
information_schema.tables group by table_schema;
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How do I run a query in mysql?
How to write date and time literals?
How do I start mysql in linux?
How do I edit a table in mysql?
How can you filter the duplicate data while retrieving records from the table?
How to create a new table in mysql?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
How many columns can a table have?
why not null is not allowed at table level
What is mvcc in mysql?
What is the difference between the LIKE and REGEXP operators?
Is mysql a programming language?
Where is the mysql config file?
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
How can you see all indexes defined for a table?