mysql show table examples

Example 1: mariadb show tables

SHOW TABLES FROM database

Example 2: mysql show all tables

show tables;