clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
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. 756656 fiddles created (13617 in the last week).

CREATE TABLE people( id SERIAL NOT NULL PRIMARY KEY, first_name TEXT NOT NULL, last_name TEXT NOT NULL );
 hidden batch(es)


INSERT INTO people(first_name, last_name) VALUES ('Alice', 'Jackson'), ('Bob', 'Lynch');
2 rows affected
 hidden batch(es)


SELECT * FROM people;
id first_name last_name
1 Alice Jackson
2 Bob Lynch
 hidden batch(es)


INSERT INTO people(id, first_name, last_name) VALUES (1, 'Alice', 'Turner') ON CONFLICT(id) DO UPDATE SET first_name = 'Alice', last_name = 'Turner';
1 rows affected
 hidden batch(es)


SELECT * FROM people;
id first_name last_name
2 Bob Lynch
1 Alice Turner
 hidden batch(es)