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

create table one_table ( id int primary key, name text ); insert into one_table values (1,'george'), (2,'alice'); create table many_table ( id int primary key, related_id int references one_table (id), data text ); insert into many_table values (1,2,'foo'), (2,2,'bar');
 hidden batch(es)


INSERT INTO many_table SET id = ( SELECT id FROM one_table JOIN many_table ON one_table.id = many_table.related_id WHERE many_table.related_id is null ) name = 'george'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'name = 'george'' at line 7
 hidden batch(es)