The database INFORMATION_SCHEMA contains the database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data dictionary and system catalog.
To pull the column names of a MySQL Table, you will have to use the below query -
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'youtube'
AND TABLE_NAME = 'videoslist';
![](http://www.beingskilled.com/sites/default/files/styles/medium/public/assets_blogs_concepts/sql-basics-learn-sql-on-beingskilled.jpg?itok=FRJhA6Mw)
Learn SQL from scratch on BeingSkilled