Answers for "how to view all columns in table mysql"

show table columns mysql command line

SHOW COLUMNS from tablename;

Posted by: Guest on April-21-2021

mysql all columns

-- MySQL
SELECT * 
FROM INFORMATION_SCHEMA.COLUMNS;

Posted by: Guest on May-15-2020

Code answers related to "how to view all columns in table mysql"