1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
CREATE TABLE t1 (a IPV6); CREATE TABLE t2 (a VARCHAR(39)); INSERT INTO t1 VALUES ("2001:db8:85a3::8a2e:370:7334"); SELECT a FROM t1; a 2001:0db8:85a3:0000:0000:8a2e:0370:7334 INSERT INTO t2 SELECT a FROM t1; SELECT a FROM t2; a 2001:0db8:85a3:0000:0000:8a2e:0370:7334 TRUNCATE t1; INSERT INTO t1 SELECT a FROM t2; SELECT a FROM t2; a 2001:0db8:85a3:0000:0000:8a2e:0370:7334 DROP TABLE t2; DROP TABLE t1; |