check table mysql code example

Example 1: mysql show tables in database

show tables;

Example 2: mysql check all tables

mysqlcheck -c mydatabasename -u root -p

Example 3: how to check tables in mysql

mysql -u user -p