title: Change database column name and its type without losing data
body: <p>I want to change name and type of column from <code>BIT(1)</code> to <code>INT(1)</code>.</p>
  
  <p>I am using MySQL Workbench.</p>
  
  <p>I tried this:</p>
  
  <pre><code>ALTER TABLE table_name ADD new_column_name INT(1)
  
  update table_name
  set new_column_name = convert(INT(1), old_column_name)
  
  ALTER TABLE table_name DROP COLUMN old_column_name
  </code></pre>
  
  <p>But I am getting this error</p>
  
  <pre><code>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 'INT(1), old_column_name)'
  </code></pre>