SAMPLE_DATA.sql

USE library;
SELECT * FROM records;
set autocommit = 0;
INSERT INTO records (Book_Name, Author_Name, Book_Number, Total_Copies)
VALUES
('The Alchemist', 'Paulo Coelho', 1001, 5),
('Atomic Habits', 'James Clear', 1002, 8),
('Rich Dad Poor Dad', 'Robert Kiyosaki', 1003, 6),
('Think and Grow Rich', 'Napoleon Hill', 1004, 4),
('The Psychology of Money', 'Morgan Housel', 1005, 7),
('Clean Code', 'Robert C. Martin', 1007, 3),
('The Pragmatic Programmer', 'Andrew Hunt', 1008, 5),
('Introduction to Algorithms', 'Thomas H. Cormen', 1009, 2),
('Deep Learning', 'Ian Goodfellow', 1011, 4),
('Database System Concepts', 'Abraham Silberschatz', 1015, 6);
UPDATE records SET Available_Copies = Total_Copies ;
SELECT * FROM records;
commit;