How to get only tables, not views using SHOW TABLES?
1
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';