SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE authors ( authors_id SERIAL PRIMARY KEY, FirstName CHARACTER VARYING(100), LastName CHARACTER VARYING(100), ); INSERT INTO authors (FirstName, LastName) VALUES ('Иванов','Петр', 1) ('Сидорова','Екатерина', 2) ('Маджестиков','Михаил', 3) ('Герасимова','Юлия', 4); SELECT * FROM authors; CREATE TABLE books ( book_id SERIAL PRIMARY KEY, title VARCHAR(255) NOT NULL, publication_year CHARACTER VARYING(30), price DECIMAL(10, 2) NOT NULL, authors_id INTEGER FOREIGN KEY (author_id) REFERENCES authors(author_id) ON DELETE CASCADE ); INSERT INTO books(title, publication_year, price, authors_id ) ('Сказки',1751, 850, 1) ('30000 Лье под водой',1905, 1100, 4) ('50ка в сумке у папы', 2023, 10000000, 2) ('Степа',1847, 300, 3); SELECT * FROM books CREATE TABLE orders ( order_id SERIAL PRIMARY KEY, orderDate DATE NOT NULL, totalAmount DECIMAL(10, 2) NOT NULL ); INSERT INTO orders(orderDate, totalAmount) (2024-12-01, 1000) (2024-12-03, 5000) (2024-12-05, 10000); SELECT * FROM orders