[Kea-users] How to insert IPv4 address with host reservation (mysql)

MRob mrobti at insiberia.net
Thu Feb 7 19:05:47 UTC 2019

Hi, I learned how to insert into mysql host reservations for the 
dhcp_identifier column like this:

INSERT INTO hosts (dhcp_identifier, hostname) VALUES 
(UNHEX(REPLACE('AA:BB:11:22:CC:33', ':', '')), 'myhost')

Can anyone help me understand how to insert IPv4 address into the 
"ipv4_address" column, the data type is integer.

Thank you.

More information about the Kea-users mailing list