title: How to add column using alter in mysql?
body: <p>How to add the column using alter by inputting the values on it?
  As the example, I want to add <em>tempID</em>'s column which has value "3" on every row</p>
  
  <p>Maybe it's something like this</p>
  
  <pre><code>ALTER TABLE NAMEYOURTABLE
     ADD COLUMN last_update TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  </code></pre>
  
  <p>but the code above is only for the timestamp, not for integer values. Thanks in advance</p>