view table in database mysql code example

Example 1: mysql show table structure

DESCRIBE table_name; # To show table structure...

Example 2: show tables mysql

SHOW TABLES;

Example 3: mysql show tables in database

show tables;