Find all MyISAM database tables and output the .sql needed to convert them to InnoDB

MyISAM convert to InnoDB

# You will need to login to mysql/mariadb (possibly as root user, or a user with access to all databases) first, usually: mysql

SELECT CONCAT('ALTER TABLE ',TABLE_SCHEMA,'.', table_name, ' ENGINE=InnoDB;') AS sql_statements
FROM information_schema.tables
WHERE TABLE_SCHEMA NOT IN ('mysql', 'information_schema', 'performance_schema', 'innodb', 'sys', 'tmp')
AND ENGINE = 'MyISAM'
AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_SCHEMA, table_name DESC;