Tuesday, November 15, 2016

How to get only column name in mysql specific table

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS WHERE
TABLE_SCHEMA = 'db_name'
AND TABLE_NAME = 'table_name';

No comments:

Post a Comment