access database mysql and show table code example
Example 1: mysql show table structure
DESCRIBE table_name; # To show table structure...
Example 2: show table mysql
# First, select your database
USE yourDb;
# Then, simply
SHOW TABLES;
DESCRIBE table_name; # To show table structure...
# First, select your database
USE yourDb;
# Then, simply
SHOW TABLES;