MySQL : convertir toutes les tables en InnoDB

Boris HUISGEN
Boris HUISGEN
|
SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' ENGINE=InnoDB;')
FROM information_schema.tables
WHERE 1=1
    AND engine = 'MyISAM'
    AND table_schema NOT IN ('information_schema', 'mysql', 'performance_schema');
Boris HUISGEN
Boris HUISGEN
Blog owner
  • #innodb
  • #mysql