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/
Convert your data online, free
Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.
