Versions Compared

Old Version 5

changes.mady.by.user Adam Darwin

Saved on

compared with

New Version 6

changes.mady.by.user Adam Darwin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
update ip2location_db3_ipv6 set
ip_from = (SUBSTRING(REPLICATE('0', 39), 1, 39 - LEN(ip_from)) + ip_from),
ip_to = (SUBSTRING(REPLICATE('0', 39), 1, 39 - LEN(ip_to)) + ip_to);


- You will get a warning. 

- Clock OK to continue

- That's it!