clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2805464 fiddles created (40815 in the last week).

select version();
version()
5.6.51
 hidden batch(es)


create table visits (ip varbinary(16) not null primary key, number_of_visits int not null)
 hidden batch(es)


insert into visits values (INET6_ATON('127.0.0.1'),1) on duplicate key update number_of_visits=number_of_visits+1
 hidden batch(es)


select INET6_NTOA(ip), number_of_visits from visits
INET6_NTOA(ip) number_of_visits
127.0.0.1 1
 hidden batch(es)


insert into visits values (INET6_ATON('127.0.0.1'),1) on duplicate key update number_of_visits=number_of_visits+1
 hidden batch(es)


select INET6_NTOA(ip), number_of_visits from visits
INET6_NTOA(ip) number_of_visits
127.0.0.1 2
 hidden batch(es)