Difference between revisions of "SQL"
From Alessandro's Wiki
(Created page with " ''this is pure code notes, check out mysql also == errors == * SQL Error '''10060''' : ** port filtered") |
|||
| Line 1: | Line 1: | ||
''this is pure code notes, check out [[mysql]] also | ''this is pure code notes, check out [[mysql]] also | ||
== statements == | |||
* get Database size in kilobytes: | |||
SELECT sum( data_length + index_length ) / 1024) 'DB Size in MB' FROM information_schema.TABLES WHERE TABLES.TABLE_SCHEMA='<database name>' GROUP BY table_schema | |||
== errors == | == errors == | ||
Revision as of 11:58, 13 January 2013
this is pure code notes, check out mysql also
statements
- get Database size in kilobytes:
SELECT sum( data_length + index_length ) / 1024) 'DB Size in MB' FROM information_schema.TABLES WHERE TABLES.TABLE_SCHEMA='<database name>' GROUP BY table_schema
errors
- SQL Error 10060 :
- port filtered
