mysql copy data from another column

Question

I have 2 columns, ip_start, ip_start_long

ip_start        |  ip_start_long
------------------------------------
0.255.255.255   |  16777215

I need to convert ip_start (INET_ATON) and copy update to ip_start_long for all rows (1 million rows)

How can I do it in php or phpmyadmin?

DevZer0 · Accepted Answer · 2013-08-16 08:55:54Z

2

well simple query will do this for you

update table set ip_start_long = INET_ATON(ip_start);

answered Aug 16, 2013 at 8:55

DevZer0

13.5k7 gold badges29 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

what if ip is ipv6? ip_start can have ipv4 & 6

you can see here that native support for ipv6 is not added. there is a link there that will take you to some udf functions