title: MySQL Syntax for setting Default Date
body: <p>How can we set element to some default date in mysql ? </p>
  
  <ul>
  <li><p>In oracle we would do something like </p>
  
  <p>start_date  DATE DEFAULT to__date('01011900','DDMMYYYY')</p>
  
  <p>mutation_date_time DATE DEFAULT SYSDATE</p>
  
  <p>CONSTRAINT entity_specification UNIQUE(external_name, start_date_time, end_date_time))</p></li>
  </ul>
  
  <p>Also do we have any site or resource where we can get MySQL equivalent syntax to Oracle Syntax. </p>
  
  <p><strong>Update</strong></p>
  
  <p>I tried to do as mentioned in answer but again am getting error message:</p>
  
  <pre><code>    create table product_offer_type(object_id INT(19), snapshot_id INT(19), PRIMARY KEY(object_id,snapshot_id), enum_value VARCHAR(64) NOT NULL, external_name VARCHAR(64) NOT NULL, description VARCHAR(255), business_validation INT(1), valid_for_start_date_time DATE DEFAULT '1900-01-10', valid_for_end_date_timeDATE DEFAULT '4712-01-01', mutation_date_time DATE DEFAULT 'SYSDATE()', mutation_user VARCHAR(32) DEFAULT 'USER');
  ERROR 1064 (42000): 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 'DEFAULT '4712-01-01', mutation_date_time DATE DEFAULT 'SYSDATE()', mutation_user' at line 1
  mysql&gt;
  </code></pre>