select round(sum(DATA_LENGTH / 1024 / 1024 ), 2) from `information_schema`.`tables` where table_schema = '%s' and table_name = '%s' % (db_name, table_name)
Company M
see mysql More about table size
- mysql Tools —— Use mysqlshow see mysql Object information , see mysql Watch size
key word : Check the table size ,mysqlshow mysqlshow --count -uroot -p test
- see mysql Watch size
// Advanced go MySQL Own management library :information_schema // Own database :dbwww58com_kuchecarlib // My own watch :t_carmodelparamvalue mysql ...
- SQL Command view Mysql Database size
SQL Command view Mysql Database size method . To know the size of each database , Steps are as follows :1. Get into information_schema database ( Stored information from other databases )use information_sc ...
- see MySQL Database size
see MySQL Database size 1. First of all to enter information_schema database ( Stored information from other databases ) ? 1 2 mysql> use information_schema; Data ...
- see mysql The method of table structure and table creation statement （ turn ）
see mysql There are three ways to structure a table :1.desc tablename; for example : To see jos_modules Table structure commands :desc jos_modules; View results :mysql> desc jos_m ...
- 【 turn 】 see mysql The method of table structure and table creation statement
from :http://blog.csdn.net/business122/article/details/7531291 see mysql There are three ways to structure a table : 1.desc tablename; for example : ...
- sql How to view all table sizes
sql How to view all table sizes . Code : declare @id int ) declare @pages int declare @dbname sysname ,) ,) ,) create tabl ...
- see mysql The size of tables and databases
from :http://xiaosu.blog.51cto.com/2914416/687835 1. Look at the size of the database use Database name SELECT sum(DATA_LENGTH)+sum(INDEX_ ...
- use SQL Command view Mysql Database size
To know the size of each database , Steps are as follows : 1. Get into information_schema database ( Stored information from other databases ) use information_schema; 2. Query the size of all data : s ...
Random recommendation
- .NET WeChat official account development -4.0 The official account is processed
One . Preface The message processing of wechat public platform is relatively perfect , There are basic text messages , To graphic message , To the picture message , Voice message , Video message , The basic principle of music message is the same , It's just that post Of xml The data is different , Before processing a message , We ...
- Cobar-Client Implementation Strategy Summary
1. data source DataSource CobarClient Of DataSource Divided into three layers ICobarDataSourceService: It encapsulates multiple DataSourceDescriptor, ...
- Use LS2J Technology in LotusScript Use in Java
We can use LS2J Technology in LotusScript To call Java class , Here's an example : 1. First of all, we need to be in the agency's (Options) part , Add the following : Uselsx "*javacon& ...
- sql windows server2008 Full set of activation codes
vs2012 - Microsoft Visual Studio Ultimate 2012 Flagship Edition Valid registration key : YKCW6-BPFPF-BT8C9-7DCTH-QXGWC- Microsoft ...
- [HackerCup Round1 3] Winning at Sports ( Dynamic programming )
Topic link :https://www.facebook.com/hackercup/problems.php?pid=688426044611322&round=344496159068801 topic ...
- ios Development of OC Basics -oc Applet
The articles in this series are mainly from personal education in learning - Teacher Ouyang Jian's iOS Developing a tutorial OC Notes made in the language teaching video , Watching the video , While recording the knowledge of the course . I suggest you go through the video first , Record the key words of knowledge points in the process of watching the video , Get to the point , And then again ...
- oracle An empty table doesn't lead out
stay oracle 11g r2 in , Use exp Sometimes you can't export an empty table , The reason is that these tables do not allocate space , Manually allocate space to export . ---- Query all empty tables under the current user : select table_name from us ...
- JS Object oriented prototype chain
Prototype chain of objects As long as it's an object, there's a prototype Prototypes are also objects As long as it's an object, there's a prototype , And prototypes are objects , So just define an object , Then we can find his prototype , So again and again , Can form a sequence of objects , This structure is called ...
- qt Layout
Speaking of qt Layout , Compared to what I used before MFC Much better , and qt Support qss, It can beautify the interface better .qt Provides several common layout management Window layout , This is a boon to the client program , You don't have to worry about how the interface controls change when the program interface zooms in or out , ...
- LaTeX： The filling of graphics （ Generate shadow graphics ）
The intranet and extranet to see the comprehensive arrangement . Wayne Tu Venn \documentclass{standalone} \usepackage{tikz} % Exporting to images requires installation imagemagick %https://t ...