title: How to change Column size of varchar type in mySQL?
body: <p>I have the following table emp : </p>
  
  <pre><code>Field   Type       Null     Key     Default     Extra   
  id      int(11)     NO      PRI     NULL    auto_increment
  name    varchar(20) YES             NULL    
  dept    varchar(20) YES             NULL    
  </code></pre>
  
  <p>Now I like to change the varchar size of name from 20 to 50. </p>
  
  <p>I have tried with the following SQL queries but the same error shows :</p>
  
  <pre><code>ALTER TABLE emp
  CHANGE COLUMN 'name' varchar(100);
  
  
  ALTER TABLE emp
  ALTER  COLUMN name varchar(100);
  </code></pre>
  
  <p>This is the ERROR :  </p>
  
  <blockquote>
    <p>1064 - You have an error in your SQL syntax; check the manual that corresponds
         to your MySQL server version for the right syntax to use
         near 'varchar(100)' at line 2</p>
  </blockquote>
  
  <p>Any idea how to change the column size of varchar type in MYSQL ? </p>