[Devel] [Users] eta for v1.2.0 - March 12

Juha Heinanen jh at tutpro.com
Tue Feb 27 20:48:14 CET 2007


Juha Heinanen writes:

 >   ALTER TABLE gw ADD address varchar(15) NOT NULL
 >   UPDATE gw SET address = INET_NTOA(((ip_addr & 0x000000ff) << 24) + ((ip_addr & 0x0000ff00) << 8) + ((ip_addr & 0x00ff0000) >> 8) + ((ip_addr & 0xff000000) >> 24))
 >   ALTER TABLE gw DROP ip_addr
 >   ALTER TABLE gw ADD ip_addr varchar(15) NOT NULL
 >   UPDATE gw SET ip_addr = address

plus one more:

ALTER TABLE gw DROP address

-- juha



More information about the Devel mailing list