Apr 27, 2017

[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
Post a Comment

Featured Post

Setup Chinese Input Method in Ubuntu 17.10 Artful

sudo apt install ibus-sunpinyin After either of those commands do not forget to restart the IBus daemon ibus restart You might need t...