mysql show tables from database code example
Example 1: mysql show all tables
show tables;
Example 2: mysql show data from table
mysql> SELECT * FROM [table name];
Example 3: mysql command show tables
SHOW TABLES;
Example 4: mysql command show tables
mysql -u user -p
Example 5: show tables mysql
Press CTRL+C to copy SHOW [EXTENDED] [FULL] TABLES
[{FROM | IN} db_name]
[LIKE 'pattern' | WHERE expr]