IDEAL SERVERS' UPWORK !

ANY SERVERS – RELiABiLiTY, SECURiTY, PERFORMANCE.

Getting type of engine of Mysql’s tables.

without comments

[root@server ~]# mysql -u root -pXXXXX -e 'select table_schema,table_name,engine from tables' information_schema
+--------------------+---------------------------------------+--------+
| table_schema       | table_name                            | engine |
+--------------------+---------------------------------------+--------+
| information_schema | CHARACTER_SETS                        | MEMORY |
| information_schema | COLLATIONS                            | MEMORY |
| information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | MEMORY |
| information_schema | COLUMNS                               | MyISAM |
....

Written by spectre

March 17th, 2014 at 11:26 am

Posted in Mysql

Leave a Reply

*