title: MySQL - How do I update the decimal column to allow more digits?
body: <p>I'm a beginner in MySQL, and I accidentally created a table with a column named </p>
  
  <pre><code>(price decimal(2,2));
  </code></pre>
  
  <p>It needs to be <code>decimal(4,2)</code> to allow 4 digits. Since I've already created it, what is the easiest way to update that decimal value to <code>decimal(4,2)</code>? Or do I need to drop that column completely, and re-create it with the correct numbers?</p>