select table_schema,table_name,engine from information_schema.tables
where table_schema not in('information_schema','mysql','performance_schema','test')
and engine='InnoDB'

posted on 2016-11-03 18:05  一天不进步,就是退步  阅读(222)  评论(0)    收藏  举报