In case you wanted for example to change all your MyISAM tables into InnoDB , and you didn’t want to go over the tables one by one, you can do the following queries.

First check that you’re doing it on the proper database.

1
2
3
4

USE information_schema;
SELECT TABLE_SCHEMA, TABLE_NAME 
  FROM TABLES 
 WHERE TABLE_SCHEMA = "your_db_name";

If it returns what you need you can then run:

1
2
3

SELECT CONCAT("ALTER TABLE `", TABLE_SCHEMA,"`.`", TABLE_NAME, "` ENGINE = INNODB; ") as MySQLCMD 
  FROM TABLES 
 WHERE TABLE_SCHEMA = "your_db_name";