MySQL features

Vertical console output

Command must end with "\G", not with semicolon.

Ex: SELECT * FROM my_table\G

Searching in DB table column names

From all DBs and tables:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "my_db_name" AND column_name LIKE "%searched_string%" \G

List all columns from the table ordered by column name:

SELECT COLUMN_NAME FROM information_schema.columns WHERE table_schema='my_db_name' AND table_name='my_table_name' ORDER BY COLUMN_NAME;

Internal informations about tables

SHOW TABLE status FROM dbname;

Measuring the time of queries (profiling)

documentation on mysql.com