0

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("127.0.0.1")).

When I use phpMyAdmin 4.5.4.1 in the "Insert" tab, I choose INET6_ATON as the function and 127.0.0.1 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 "127.0.0.1" and '127.0.0.1' as the value. They turn into INET6_ATON(0x"127.0.0.1") and INET6_ATON(0x'127.0.0.1').

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

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.