MySql useful tips

mysql -u -p -e
"select
TABLE_NAME, COLUMN_NAME, COLUMN_DEFAULT,
IS_NULLABLE, DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH,
NUMERIC_PRECISION, NUMERIC_SCALE,
COLUMN_TYPE, COLUMN_KEY, EXTRA,
PRIVILEGES, COLUMN_COMMENT
from information_schema.columns
where
TABLE_SCHEMA = ''
order by TABLE_NAME, COLUMN_NAME "
> tbl


select TABLE_NAME, TABLE_ROWS from information_schema.TABLES where TABLE_SCHEMA = '' order by TABLE_ROWS ;