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

  1. mysql Tools —— Use mysqlshow see mysql Object information , see mysql Watch size

    key word : Check the table size ,mysqlshow mysqlshow --count -uroot -p test

  2. see mysql Watch size

    // Advanced go MySQL Own management library :information_schema // Own database :dbwww58com_kuchecarlib // My own watch :t_carmodelparamvalue mysql ...

  3. 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 ...

  4. 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 ...

  5. 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 ...

  6. 【 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 : ...

  7. 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 ...

  8. 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_ ...

  9. 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

  1. .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 ...

  2. Cobar-Client Implementation Strategy Summary

    1. data source DataSource CobarClient Of DataSource Divided into three layers ICobarDataSourceService: It encapsulates multiple DataSourceDescriptor, ...

  3. 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& ...

  4. 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  ...

  5. [HackerCup Round1 3] Winning at Sports ( Dynamic programming )

    Topic link :https://www.facebook.com/hackercup/problems.php?pid=688426044611322&round=344496159068801 topic ...

  6. 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 ...

  7. 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 ...

  8. 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 ...

  9. 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 , ...

  10. 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 ...