[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