- Original Message -
> From: "Adarsh Sharma"
> I am able to fetch the output individually, but I try that I access
> all information through one command :
> mysql> SELECT table_schema 'database',table_name 'Table', concat(
> round( sum( data_length + index_length ) / ( 1024*1024*1024) ,
of your information_schema.tables table might provide insight :-)
- Original Message -
> From: "Adarsh Sharma"
> To: mysql@lists.mysql.com
> Sent: Tuesday, 15 March, 2011 5:56:17 AM
> Subject: Unexpected Select Output
> Dear all,
> Today I shoot a query to know the s
Dear all,
Today I shoot a query to know the size of tables in a particular
database, but don't know why it prints only the output of only one
table. Here is my query & output :
mysql> SELECT table_schema 'database',table_name 'Table', concat( round(
sum( data_length + index_length ) / ( 1024