phpMyAdmin how to run an output query? run a batch? In phpMyAdmin the code below just outputs a list of sql statements for each table:

SET @DATABASE_NAME = 'my_db';
SELECT  CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = @DATABASE_NAME
AND     `ENGINE` = 'MyISAM'
AND     `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;


How would I actually execute this to change all the tables? I've seen people say "batch" but I'm not sure if that is what I'm looking for.
It is actually easiest to simply copy&amp;paste the SQL statements.  Don't bother with trying to find and "eval".

It is even easier in the mysql commandline tool.

Here are my tips on gotchas that sometimes occur in the conversion from MyISAM to InnoDB:  http://mysql.rjweb.org/doc.php/myisam2innodb