SQLize Online / PHPize Online  /  SQLtest Online

create table gift_certificate ( id int primary key, name varchar(64) ); create table tags ( id int primary key, tag_name varchar(64) ); create table gift_certificate_to_tag_relation ( gift_certificate_id int, tag_id int, foreign key (gift_certificate_id) references gift_certificate(id), foreign key (tag_id) references tags(id) ); insert into gift_certificate values (1, 'Name1'); insert into tags values (1, 'Tag1'); insert into gift_certificate_to_tag_relation values (1, 1); select * from gift_certificate join gift_certificate_to_tag_relation on gift_certificate_to_tag_relation.gift_certificate_id = gift_certificate.id join tags on tags.id = gift_certificate_to_tag_relation.tag_id where gift_certificate.id = 1; START TRANSACTION; delete from gift_certificate_to_tag_relation where gift_certificate_id = 10; delete from gift_certificate where id = 1; COMMIT; select * from gift_certificate join gift_certificate_to_tag_relation on gift_certificate_to_tag_relation.gift_certificate_id = gift_certificate.id join tags on tags.id = gift_certificate_to_tag_relation.tag_id where gift_certificate.id = 1;