Answers for "mysql get columns of table"

show table columns mysql command line

SHOW COLUMNS from tablename;

Posted by: Guest on April-21-2021

mysql get column names from table

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='yourdatabasename' 
    AND `TABLE_NAME`='yourtablename';

Posted by: Guest on December-18-2020

Code answers related to "mysql get columns of table"