MySql: Show columns but exclude everything except the field names

June 5, 2023 by Tarik

SELECT column_name
FROM information_schema.columns
WHERE  table_name="your_table"
   AND table_schema="database_name"