Tablelarga malumotni kiritish :
-- Insert data into Regions table
INSERT INTO Regions (region_id, region_name, location, contact_number, email)
VALUES
(1, 'North Region', 'CityA', '123-456-7890', 'northregion@example.com'),
(2, 'South Region', 'CityB', '987-654-3210', 'southregion@example.com'),
(3, 'East Region', 'CityC', '555-111-2222', 'eastregion@example.com'),
(4, 'West Region', 'CityD', '555-333-4444', 'westregion@example.com'),
(5, 'Central Region', 'CityE', '555-555-6666', 'centralregion@example.com'),
(6, 'Coastal Region', 'CityF', '555-777-8888', 'coastalregion@example.com');
-- Insert data into Libraries table
INSERT INTO Libraries (library_id, library_name, region_id, address, contact_number, email)
VALUES
(101, 'CityA Library', 1, '123 Main St', '555-1111', 'cityalibrary@example.com'),
(102, 'CityB Library', 2, '456 Oak St', '555-2222', 'cityblibrary@example.com'),
(103, 'CityC Library', 3, '789 Elm St', '555-3333', 'cityclibrary@example.com'),
(104, 'CityD Library', 4, '101 Pine St', '555-4444', 'citydlibrary@example.com'),
(105, 'CityE Library', 5, '202 Cedar St', '555-5555', 'cityelibrary@example.com'),
(106, 'CityF Library', 6, '303 Birch St', '555-6666', 'cityflibrary@example.com');
-- Insert data into Books table
INSERT INTO Books (book_id, title, author, genre, publication_year, available_copies, library_id)
VALUES
(201, 'Book1', 'Author1', 'Fiction', 2010, 10, 101),
(202, 'Book2', 'Author2', 'Non-Fiction', 2015, 15, 101),
(203, 'Book3', 'Author3', 'Mystery', 2005, 8, 102),
(204, 'Book4', 'Author4', 'Science Fiction', 2018, 12, 102),
(205, 'Book5', 'Author5', 'Romance', 2012, 20, 103),
(206, 'Book6', 'Author6', 'Biography', 2017, 7, 103);
Do'stlaringiz bilan baham: |
