Saturday 6 August 2022

MySQL change sroage for all tables

MySQL move from MyISAM to InnoDB Simple dynamic SQL to change stoage type in MySQL SELECT concat('alter table ', table_name, ' engine=innodb;') SQL_strg FROM information_schema.tables WHERE table_schema = 'db_dev_db' and engine='MyISAM';