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 _______________________________________________ Devel mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/devel
