title: How can I convert all InnoDB Tables to MyISAM?
body: <p>Hi guys I'm searching for a methode (sql code) with which I can convert in my WordpressDB all InnoDBs to MyISAM .</p>
  
  <p>My code since now is:</p>
  
  <pre><code>SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME,' ENGINE=MyISAM;') FROM Information_schema.TABLES WHERE ENGINE = 'InnoDB'
  </code></pre>
  
  <p>This gives me back:</p>
  
  <pre><code>ALTER TABLE db.wp_comments ENGINE=MyISAM;
  ALTER TABLE db.wp_links ENGINE=MyISAM;
  ALTER TABLE db.wp_options ENGINE=MyISAM;
  ALTER TABLE db.wp_postmeta ENGINE=MyISAM;
  ALTER TABLE db.wp_posts ENGINE=MyISAM;
  ALTER TABLE db.wp_term_relationships ENGINE=MyISAM;
  ALTER TABLE db.wp_term_taxonomy ENGINE=MyISAM;
  ALTER TABLE db.wp_termmeta ENGINE=MyISAM;
  ALTER TABLE db.wp_terms ENGINE=MyISAM;
  ALTER TABLE db.wp_usermeta ENGINE=MyISAM;
  ALTER TABLE db.wp_users ENGINE=MyISAM;
  </code></pre>
  
  <p>Now I want to execute all of this rows at once
  I want to save all the results in one variable and execute them. But a sql variable can just save one row... How do I execute now all of this rows at once with just plain sql code?</p>
  
  <p>Thanks in advance</p>
  
  <p>P.S.: can I use "Update" to solve this problem as update may can update the engine to MyISAM?</p>