mysql -e 'DESCRIBE users;' mydb

Category: Databases & SQL

mysql -e 'DESCRIBE users;' mydb

Show a table's columns

Lists column names, types, nullability, keys, and defaults for users; SHOW COLUMNS FROM users is equivalent. Related: SHOW CREATE TABLE for the full DDL.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.