I have a table created with

Create table log (
    ip VARBINARY(16)

I can insert into the table with Insert into log values (INET6_ATON("")).

When I use phpMyAdmin in the "Insert" tab, I choose INET6_ATON as the function and as the value. When I press "Go", the query becomes

INSERT INTO `log` (`ip`) VALUES (INET6_ATON(0x127.0.0.1))

I have also tried "" and '' as the value. They turn into INET6_ATON(0x"") and INET6_ATON(0x'').

How can I use phpMyAdmin to insert with INET6_ATON('')?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.