How to get column names from Mysql table

by

We can use information_schema.columns for getting column information

SELECT column_name FROM information_schema.columns WHERE table_schema = ‘My_Schema_Name’ AND table_name = ‘My_Table_Name’

See also:

How to get column names from Sql Server table

How to get column names from DB2 table

How to get column names from Oracle table

How to get column names from PostgreSQL table

How to get column names from SQLite table

Some MySQL tools you can try: https://www.withdata.com/mysql/