title: search simple way to alter multi tables in one time in mysql
body: <p>i have a lot of tables that start with some prefix , </p>
  
  <p>and i want to alter this tables </p>
  
  <p>what is the simple way  to do this (instead run over all tables)</p>
  
  <p>i mean something like :</p>
  
  <pre><code>ALTER TABLE  LIKE tablenameprefix% ADD INDEX `NewIndex1` (`field`);
  </code></pre>
  
  <p>how can i do this ?</p>
  
  <p>thanks</p>
  
  <p><strong>EDIT :</strong></p>
  
  <p>can i do a kind of loop not in stored procedure ?
  by select the names of tables from</p>
  
  <pre><code>SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_NAME LIKE 'tableprefix%'
  </code></pre>