title: MySQL Alter table add column with default of 1
body: <p>I have read most of the posts concerning MySQL ALTER TABLE but can't find an answer to my issue.</p>
  
  <p>I have a script that adds a new column to a table, this works fine but the issue I have is it is not setting the default value for the new column. Am I missing something:</p>
  
  <pre><code>ALTER TABLE Hist ADD S1 VARCHAR( 5 ) DEFAULT '1', ADD comments_S1 TEXT
  </code></pre>
  
  <p>The above is the code I am using.</p>
  
  <p>Any idea's</p>
  
  <p>Many thanks in advance for your time.</p>