20 lines
371 B
Markdown
20 lines
371 B
Markdown
# MySQL
|
|
|
|
## Query thats show essential information about MySQL tables
|
|
|
|
MySQL internal databases/schemas are excluded in `WHERE` statement.
|
|
|
|
```sql
|
|
SELECT
|
|
TABLE_SCHEMA,
|
|
TABLE_NAME,
|
|
TABLE_TYPE,
|
|
ENGINE,
|
|
ROW_FORMAT,
|
|
TABLE_ROWS
|
|
FROM
|
|
information_schema.tables
|
|
WHERE
|
|
TABLE_SCHEMA NOT IN ("performance_schema", "information_schema", "mysql");
|
|
```
|