title: How to define the default values for a column when creating tables in MySQL?
body: <p>What is the SQL to define <code>DEFAULT</code> values in MySQL?</p>
  
  <p>In the code below what needs to be added / changed to give IsObsolete a default value of <code>N</code>?</p>
  
  <pre><code>CREATE TABLE Team
  (
      TeamId              CHAR(16) NOT NULL,
      DateCreated          TIMESTAMP NOT NULL,
      IsObsolete           CHAR(1) NOT NULL DEFAULT N,
      UpdateTime           TIMESTAMP NOT NULL
  );
  </code></pre>