title: mysql how to get duplicate data from each UPDATE.?
body: <p>I have a table with following field...</p>
  
  <pre><code>student_id, name, email, age
  </code></pre>
  
  <p>I use below code for update my student table data:</p>
  
  <pre><code>$this-&gt;db-&gt;query("UPDATE " . DB_PREFIX . "student SET name = '" . $this-&gt;db-&gt;escape($data['name']) . ", email= '" . $this-&gt;db-&gt;escape($data['email']) . ", age= '" . $this-&gt;db-&gt;escape($data['age']) . " WHERE student_id = '" . (int)$student_id . "'");
  </code></pre>
  
  <p>My question is how can I get <strong>DUPLICATE</strong> field for when each updates? I mean when we update my table, the new data must be a duplicate table with new added data's, like copy of the previous data with updated....  </p>
  
  <p><em>I am not much expert with mysql.</em></p>