title: Change the Datatype of a Column in the entire Database - MySQL
body: <p>I am new to MySQL. I have designed few tables with Char datatype. Now I want to change all the char datatype columns to Varchar with respective size mentioned in Char.</p>
  
  <pre><code>For example.
  Existing - Phone Char(10) 
  Expected - Phone Varchar(10)
  </code></pre>
  
  <p>There are around 50 Plus tables. I know how to alter the datatype for each and every table and column but is there any better way to change the datatype in a single shot.</p>