Answers for "list all columns for a given table mysql"

mysql all columns

-- MySQL
SELECT * 
FROM INFORMATION_SCHEMA.COLUMNS;

Posted by: Guest on May-15-2020

mysql show table fields

DESCRIBE my_table;

Posted by: Guest on October-25-2020

mysql list table columns

DESCRIBE [TABLE_NAME];

Posted by: Guest on July-01-2021

Code answers related to "list all columns for a given table mysql"