title: Can Alter Table Engine = InnoDB be run on multiple tables at the same time?
body: <p>When it comes to MySQL and PHPMyAdmin, I'm not a novice, but I'm closer to novice than expert. Hopefully what I ask for is doable, and that someone will provide me with a simple, cut-n-paste SQL query to make it happen.</p>
  
  <p>I need to convert around 9 tables in each of 12 dbs from MyISAM to InnoDB, and I'm hoping I can do all the tables in one db with a single query rather than having to click-and-wait for each and every table in PHPMyAdmin. Basically, is there a way to run "ALTER TABLE <code>foo</code> ENGINE = InnoDB" on multiple tables at once via a query run in PHPMyAdmin?</p>