[sql] бібліотека
Viewer
- CREATE DATABASE `Бібліотека`;
- USE library;
- CREATE TABLE Authors (
- author_id INT AUTO_INCREMENT PRIMARY KEY,
- first_name VARCHAR(100),
- last_name VARCHAR(100),
- birthdate DATE,
- nationality VARCHAR(100)
- );
- CREATE TABLE Books (
- book_id INT AUTO_INCREMENT PRIMARY KEY,
- title VARCHAR(255),
- author_id INT,
- page_count INT,
- genre VARCHAR(100),
- publication_year INT,
- FOREIGN KEY (author_id) REFERENCES Authors(author_id)
- );
- CREATE TABLE Publishers (
- publisher_id INT AUTO_INCREMENT PRIMARY KEY,
- name VARCHAR(255),
- country VARCHAR(100)
- );
- Додамо авторів
- INSERT INTO Authors (first_name, last_name, birthdate, nationality)
- VALUES ('Stephen', 'King', '1947-09-21', 'American'),
- ('J.K.', 'Rowling', '1965-07-31', 'British'),
- ('Leo', 'Tolstoy', '1828-09-09', 'Russian');
- -- Додамо книги
- INSERT INTO Books (title, author_id, page_count, genre, publication_year)
- VALUES ('The Shining', 1, 447, 'Horror', 1977),
- ('Harry Potter and the Philosopher''s Stone', 2, 223, 'Fantasy', 1997),
- ('War and Peace', 3, 1225, 'Historical Fiction', 1869);
- -- Додамо видавництва
- INSERT INTO Publishers (name, country)
- VALUES ('Doubleday', 'USA'),
- ('Bloomsbury Publishing', 'UK');
Editor
You can edit this paste and save as new:
File Description
- бібліотека
- Paste Code
- 30 Apr-2024
- 1.31 Kb
You can Share it:
Latest Code Pastes