SQLize Online / PHPize Online  /  SQLtest Online

create Table person ( id integer, name text, section text, PRIMARY KEY (id) ); create Table fruit ( id integer, name text, personid integer, PRIMARY KEY (id), FOREIGN KEY (personid) REFERENCES person(id)); insert into person values (1, 'ВАНЯ', '1 отдел'), (2, 'Петя', '2 отдел'), (3, 'Коля', '3 отдел'); Select * from person; insert into fruit values (1, 'БАНАН', 1), (2, 'БАНАН', 1), (3, 'ЯБЛОКО', 2); Select * from fruit; delete (select 1 from fruit); select * from fruit;