SELECT column_name FROM information_schema.columns WHERE table_schema = 'YOUR_DATABASE_NAME' AND table_name = 'YOUR_TABLE_NAME' SHOW COLUMNS FROM mydb.mytable;
show full tables where Table_Type = 'BASE TABLE'
show tables
SHOW COLUMNS FROM [table_name]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip