title: Update MySQL new IPv6 column with existing IPv4 column data
body: <p>I have the following two columns in a MySQL database table named "ip_test":</p>
  
  <ul>
  <li><code>ipv4</code> as <code>INT(11)</code> (example value for 127.0.0.1: <code>2130706433</code>).</li>
  <li><code>ipv6</code> as <code>VARBINARY</code> (example value for 127.0.0.1: <code>0xFE800000000000000202B3FFFE1E8329</code>).</li>
  </ul>
  
  <p>What is the simplest manner to effectively convert the data (for a visual demonstration of the idea: <code>UPDATE ip_test SET ipv6=ipv4;</code>) though properly?</p>