如何查询mysql的表

SHOW TABLES [FROM db_name] [LIKE 'pattern' | WHERE expr]

SHOW TABLES;

show columns from table_name from database_name;

show columns from database_name.table_name;

show index from table_name;