1 2 3 4 5 6 7 8 9 10 |
CREATE TABLE t1 (a IPV6); show create table t1; INSERT INTO t1 VALUES ("fe8::b3ff:fe1a:8329"); INSERT INTO t1 VALUES ("::1"); INSERT INTO t1 VALUES ("::192.168.100.10"); INSERT INTO t1 VALUES ("2001:db8:85a3::8a2e:370:7334"); SELECT a FROM t1; DELETE FROM t1 WHERE a = "0000:0000:0000:0000:0000:0000:0000:0001"; SELECT a FROM t1; DROP TABLE t1; |