How to View Table size,rows with table names using query in mysql...

Hi Friends,
                  If you want to see the table details like how much size are using the table and how many   rows contained in table with table name wise, then its very simple please use below mentioned query. and see the result.

SELECT TABLE_NAME AS "Table Name", table_rows AS "Quant of Rows",  ROUND((data_length + index_length)/(1024*1024),2) AS "Total Size Mb" FROM information_schema.TABLES WHERE information_schema.TABLES.table_schema='databasename';

Regards,
Sampan

Comments

Post a Comment

Popular posts from this blog

How to Read Excel File in VC++....

Image
Hi Guys,               If you want to read your Excel sheet using  c++ application then don't worry go for the below mentioned steps and connect your apps and with c++.But before doing this you need to install the Visual Studio 6.0 and develop a win32 console application with c++ source file. STEPS:       1. Keep libxl-3.1.0 inside c headerfiles.       2. Include include folder of libxl into vc++ Tools->options->Directories include files. 3. Include the library file of libxl in vc++6.0 Tools->options->Directories library files.   4. Include the bin file of libxl in vc++6.0 Tools->options->Directories Executable files.       5.       Keep the libxl.dll in current working folder.                      Sample Code for reading Excel file  in C++: #include <iostream>        #include <wchar.h>       #include "libxl.h"       #pragma comment(lib, "libxl")       u
Read more

Window could not start the Apache tomcat 6 on Local Computer.For more information, review the System Events Logs.If this is a non-Microsoft service,contact service vendor, and refer to service-specific error code 0.

Image
Hi Guys,               Several times we have faced the problem with Apche Tomcat 6 service, It seems fail to start the service of Tomcat Apache and gettting error code 0 even its not work on installation again below is the snapshot of error. So I am writing technique how can we start the Tomcat Apache Services , Just copy one file & paste into Tomcat Apache bin folder please follow the some steps. Follow the below mentioned steps:  1. Copy the file(msvcr71.dll) from location  C:\Program Files\Java\jdk1.6.0_02\bin\  2. Paste the (msvcr71.dll) file into location      C:\Program Files\Apache Software Foundation\Tomcat6.0\bin  3.  After paste start the tomcat service and it will be started and works.  4.  For testing the apache hit the browser with http://localhost:8080/ it display the index page of Apache tomcat it means apache is working fine. Hope this will work for You. Have a Nice day...)
Read more

How to Bind Multiple SMPP Acounts Using Kannel SMS Gateway.

Hi guys,              Below I have written the script of complete kannel configuration in which I have binded the multiple SMPP accounts with mysql database. Please change your configuration according to your requirement. It is 100 % worked for me and hope it will work for you also. # CORE # # There is only one core group and it sets all basic settings # of the bearerbox (and system). You should take extra notes on # configuration variables like 'store-file' (or 'store-dir'), # 'admin-allow-ip' and 'access.log' group = core admin-port = 13000 smsbox-port = 13001 admin-password = bar dlr-storage = mysql log-file = "/var/log/kannel/kannel.log" access-log = "/var/log/kannel/bearerbox-access.log" access-log-clean = true log-level = 0 box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" # SMSC CONNECTIONS # # SMSC connections are created in bearerbox and they handle SMSC specific # protocol and m
Read more