Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Using SHOW and DESCRIBE to Review Table Structures

SHOW DATABASES; SHOW TABLES [FROM db_name]; SHOW CREATE TABLE table_name; DESCRIBE table_name;