title: How to use CHAR_LENGTH() in CREATE TABLE query - MYSQL
body: <p>My question may sound vague but am going to try as much as possible to make it clear enough. Prior to this, I have made some research on the internet and other SO pages but to no avail.
  Is it possible to use <code>CHAR_LENGTH()</code> function in a <code>CREATE TABLE</code> clause like we usually do in <code>SELECT</code> Clause :</p>
  
  <pre><code>SELECT CHAR_LENGTH("SQL Tutorial") AS LengthOfString;
  </code></pre>
  
  <p>What I want to do is similar to this:</p>
  
  <pre><code>CREATE TABLE `tbl_content` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `content` varchar(32) NOT NULL,
    `no_of_chars` int(4) NULL DEFAULT CHAR_LENGTH(`content`) ,
    PRIMARY KEY (`id`)
  )
  </code></pre>
  
  <p>But the above <code>CREATE</code> statement gives an error near <code>CHAR_LENGTH</code>.
  Precisely, During insertion of a record into such a table, I want the server to be able to read the length of the <code>content</code> field and store in <code>no_of_chars</code> field as default value.</p>
  
  <p><strong>Is this POSSIBLE?</strong></p>