SHOW TABLE STATUS FROM `DB_NAME` WHERE ENGINE IS NOT NULL;
SHOW TABLE STATUS FROM `DB_NAME` WHERE NAME IN (‘table_1‘,‘table_2‘) AND ENGINE IS NOT NULL;
SHOW TABLE STATUS FROM `DB_NAME` WHERE ENGINE IS NOT NULL;
SHOW TABLE STATUS FROM `DB_NAME` WHERE NAME IN (‘table_1‘,‘table_2‘) AND ENGINE IS NOT NULL;
原文：https://www.cnblogs.com/Rampage/p/8244622.html