Sep 26, 2018

[HDGEM] How to show column names in MySQL

The quickest way to see a list of columns for a table is to use DESCRIBE.
  • DESCRIBE [table name]
  • SHOW COLUMNS FROM [table name]
  • SELECT COLUMN_NAME FROM information_schema.


--
Posted By Blogger to HDGEM at 4/27/2017 10:38:00 AM