1
CREATE TABLE t1 (a IPV6);
2
CREATE TABLE t2 (a VARCHAR(39));
3
INSERT INTO t1 VALUES ("2001:db8:85a3::8a2e:370:7334");
6
2001:0db8:85a3:0000:0000:8a2e:0370:7334
7
INSERT INTO t2 SELECT a FROM t1;
10
2001:0db8:85a3:0000:0000:8a2e:0370:7334
12
INSERT INTO t1 SELECT a FROM t2;
15
2001:0db8:85a3:0000:0000:8a2e:0370:7334