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 know if mysql is installed on windows?
What are different types of queries?
What is the use of procedure in mysql?
How can you calculate the sum of any column of a table?
What is the current root password of mysql?
How do you concatenate strings in mysql?
I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.
What is regexp?
What, if a table has one column defined as TIMESTAMP?
Can you tell few best practices to be followed for optimization in sql?
how to take mysql database backup?
How do I start mysql?
What is data node in mysql cluster?
What are the security alerts while using mysql?
Is postgresql better than mysql?
