DESCRIBE table_name; # To show table structure...
mysql> SELECT * FROM [table name];
# First, select your database USE yourDb; # Then, simply SHOW TABLES;
SHOW TABLES;
show tables;
mysql -u user -p
Press CTRL+C to copy SHOW [EXTENDED] [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr]