Web Hosting Talk : Web Hosting Main Forums : Hosting Software and Control Panels : Sql command to view tables that use Innodb engine

[hostyourdream]

Hello

I login to ssh and then to mysql and i want to ask please what command i must use to view on which tables i use the Innodb engine?

Thank you

[Tristan Perry]

Try this command?

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

[hostyourdream]

It doesn't work

MariaDB [(none)]> SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb'
->

I just get this:

->

[Tristan Perry]

Ah. At command line you must put a semi-colon at the end

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

Semi-colon means the end of the command, and thus MySQL server runs the command. (You can miss out the semi colon using something like phpMyAdmin )

[hostyourdream]

Ok thanks