title: How to define @@system_time_zone as default value of a column of an existing table in MySQL?
body: <p>I am trying to define @@system_time_zone as the default value of a column I am trying to add to an existing table.
  e.g.</p>
  
  <pre><code>ALTER TABLE T1 ADD COLUMN TIME_ZONE CHAR(64) NOT NULL DEFAULT @@system_time_zone;
  </code></pre>
  
  <p>This throws me a MySQL syntax error. I tried enclosing @@system_time_zone within single quotes. I am right now splitting this into two, as follows:</p>
  
  <pre><code>ALTER TABLE T1 ADD COLUMN TIME_ZONE CHAR(64) NOT NULL;
  
  UPTATE T1 SET TIME_ZONE=@@system_time_zone;
  </code></pre>
  
  <p>This works but it is obvious that this is not an ideal solution. I have tried searching Google/StackOverFlow but to no avail. Can anyone let me know if there is a correct syntax that can achieve this/any other alternative by which this can be achieved?</p>