Working with IPv6 in MariaDB – the INET6 datatype
Ian Gilfillan from the MariaDB Foundation covers the INET6 data type, available from MariaDB 10.5, including storing and retrieving data, as well as upgrading to use it from earlier versions of MariaDB.
0:00 Start
0:40 Creating a table with an INET data type
0:50 Inserting IPv6 values
1:50 Inserting IPv4 values
2:22 Retrieving values
3:14 Comparing and mixing
5:33 Migrating from an earlier version of MariaDB
Knowledge Base links:
* INET6 data type (https://mariadb.com/kb/en/inet6/)
* INET6_ATON function (https://mariadb.com/kb/en/inet6_aton)
* INET6_NTOA function (https://mariadb.com/kb/en/inet6_ntoa/)
* UNHEX function (https://mariadb.com/kb/en/unhex/)
* COALESCE function (https://mariadb.com/kb/en/coalesce/)
Music: “Acid Trumpet” Kevin MacLeod (incompetech.com) Licensed under Creative Commons: By Attribution 4.0 License