The following query will get column names from table in MySql > 5
|
1 |
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'table_name'; |
where
- database_name is your database
- table_name is your table