title: LAST_INSERT_ID returns 0 in an insert query
body: <p>Please I am trying to insert the last ID into a different column of the same row in mysql. This is what i have tried</p>
  
  <pre><code> Insert Query
  
  "INSERT INTO table(char,name) VALUES (LAST_INSERT_ID(),'KOKO')"
  
  This is the Output
  ID  |   char    |   name    |
  1   |    0      |   KOKO    |
  </code></pre>
  
  <p>HOWEVER, I expect that when a row is inserted the column <code>char</code> will insert the <code>ID</code> value as well; What i expect</p>
  
  <pre><code>    ID  |   char    |   name    |
      1   |    1      |   KOKO    |
  </code></pre>
  
  <p>Please is there something i am doing wrong. Will be glad to know, thanks in advance</p>