title: MySQL Functions in Codeigniter Data
body: <p>Using codeigniter I'm trying to insert a row into my database, but I want the data in the row to be generated by MySQL. What is the proper way of doing it?</p>
  
  <pre><code>$data['my_id'] = 'UUID()';
  $db-&gt;insert('my_table',$data);
  </code></pre>
  
  <p>Obviously the above won't work, but how can I make it function?</p>
  
  <p>EDIT:
  Theoretically this is what the above should produce:</p>
  
  <pre><code>INSERT INTO my_table (my_id) VALUES (UUID());
  </code></pre>
  
  <p>Naturally my actually query isn't that simple, but that should get the point across.</p>