insert_data.sql

-- INSERT INTO departments(departmentid, departmentname)
-- VALUES  (1, 'English Department'),
--         (2, 'Computer Science Department'),
--         (3, 'Social Science Department');


-- INSERT INTO employees (employeeid, firstname, lastname, age, departmentid)
-- VALUES (1, 'John', 'Doe', 30, 1),
--        (2, 'Jane', 'Smith', 25, 2),
--        (3, 'Mike', 'Wilson', 42, 1),
--        (4, 'Alice', 'Johnson', 28, 3);


-- INSERT INTO customers(customerid, firstname, lastname, email)
-- VALUES  (1, 'Rezaul', 'Shaon', 'rkshaon.ist@gmail.com'),
--         (2, 'Humayun', 'Heru', 'humayunkabir@gmail.com'),
--         (3, 'Muhaiminul', 'Islam', 'mishihab@gmail.com');

-- INSERT INTO orders(orderid, productid, quantity)
-- VALUES  (1, 1, 10),
--         (2, 1, 10),
--         (1, 2, 100),
--         (2, 2, 100);

-- INSERT INTO users(username, password)
-- VALUES  ('rkshaon', 'rkshaon'),
--         ('rk', 'rkshaon');

INSERT INTO students (studentid, firstname, lastname, age, grade)
VALUES  (4, 'Rezaul', 'Shaon', 59, 'D'),
        (5, 'Rezaul', 'Shaon', 29, 'B');