Blog

List out all the mysql database tables with storage engine INNODB

Tags: databasesinnodbMySQLstorage engine

Published on: October 19, 2010 by George K.

List out all the mysql database tables with storage engine INNODB

Scenario:

Simple 🙂 Issue the mysql command

SELECT table_schema, table_name  FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb';

Category : General, Howtos, MySQL, Training, Troubleshooting

George K.

George K.

George started his career in web hosting and Linux technical support in the year 2004 and is with SupportSages since 2009. He has keen interest in server optimizations, custom security solutions, hacked server recovery, cyber forensic and high availability fail over system design and implementation. George loves long drives and is passionate about art and literature.

You may also read:

Comments

Add new commentSIGN IN

Let's Connect

Get new updates

Categories

$0.000 items