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. 2805490 fiddles created (40771 in the last week).

select version();
version()
10.5.12-MariaDB
 hidden batch(es)


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


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


select * from visits
ip number_of_visits
::127.0.0.1 1
 hidden batch(es)


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


select * from visits
ip number_of_visits
::127.0.0.1 2
 hidden batch(es)