SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE book ( book_id INT GENERATED BY DEFAULT ON NULL AS IDENTITY, title VARCHAR(50), author VARCHAR(30), price DECIMAL(8, 2), amount INT ); INSERT ALL INTO book (book_id, title, author, price, amount) VALUES (1, 'Мастер и Маргарита','Булгаков М.А.',670.99, 3) INTO book (book_id, title, author, price, amount) VALUES (2, 'Белая гвардия', 'Булгаков М.А.', 540.50, 5) INTO book (book_id, title, author, price, amount) VALUES (3, 'Идиот', 'Достоевский Ф.М.', 460.00, 10) INTO book (book_id, title, author, price, amount) VALUES (4, 'Братья Карамазовы', 'Достоевский Ф.М.', 799.01, 2) INTO book (book_id, title, author, price, amount) VALUES (5, 'Стихотворения и поэмы','Есенин С.А.', 650.00, 15) SELECT * FROM dual; CREATE TABLE supply ( supply_id INT GENERATED ALWAYS AS IDENTITY PRIMARY KEY, title VARCHAR(50), author VARCHAR(30), price DECIMAL(8,2), amount INT); INSERT INTO supply(title, author, price, amount) VALUES ('Лирика','Пастернак Б.Л.', 518.99, 2); INSERT INTO supply(title, author, price, amount) VALUES ('Черный человек', 'Есенин С.А.', 570.20, 6); INSERT INTO supply(title, author, price, amount) VALUES ('Белая гвардия', 'Булгаков М.А.', 540.50, 7); INSERT INTO supply(title, author, price, amount) VALUES ('Идиот', 'Достоевский Ф.М.', 360.80, 3); INSERT INTO book (book_id, title, author, price, amount) SELECT supply_id, title, author, price, amount FROM supply WHERE author <> 'Достоевский Ф.М.' and author <> 'Булгаков М.А.'; SELECT * FROM book;