Using MSQL Ive created two tables below about Students borro

Using MSQL ,I\'ve created two tables below about Students borrowing books from library, and Faculty also borrowing books from a library. What I need to do now is populate these tables with 20 rows each. That\'s what i\'m stuck on. I don\'t know how to populate the tables! Someone please help. It can be random names or whatever, I just need to populate them... Please help! Thank you so much.

CREATE TABLE Student_Borrow(

Reservation_Code INT NOT NULL AUTO_INCREMENT,

StudentID INT,

ResourceID INT,

StaffID INT,

Date DATE,

TimeIN TIME,

TimeOut TIME,

LateFee FLOAT,

PRIMARY KEY (Reservation_Code),

FOREIGN KEY (StudentID) REFERENCES Student(StudentID),

FOREIGN KEY (ResourceID) REFERENCES Resources(ResourceID),

FOREIGN KEY (StaffID) REFERENCES Staff(StaffID)

);

set foreign_key_checks=0

CREATE TABLE Faculty_Borrow(

Reservation_Code INT NOT NULL AUTO_INCREMENT,

FacultyID INT,

ResourceID INT,

StaffID INT,

Date DATE,

TimeIN TIME,

TimeOut TIME,

LateFee FLOAT,

PRIMARY KEY (Reservation_Code),

FOREIGN KEY (FacultyID) REFERENCES Faculty(FacultyID),

FOREIGN KEY (ResourceID) REFERENCES Resources(ResourceID),

FOREIGN KEY (StaffID) REFERENCES Staff(StaffID)

);

set foreign_key_checks=0

Solution

A. insert into Student_Borrow(StudentID,ResourceID,StaffID,Date,TimeIN,TimeOut,LateFee) values(1,1,1,\'2016-11-17\',\'08:00:00\',\'12:00:00\',100.00);

Here time is in format hh:mm:ss and date as yyyy-mm-dd

B.

insert into Faculty_Borrow(FacultyID,ResourceID,StaffID,Date,TimeIN,TimeOut,LateFee) values(1,1,1,\'2016-11-17\',\'08:00:00\',\'12:00:00\',100.00);

Here time is in format hh:mm:ss and date as yyyy-mm-dd

Like above insert statements you can have your own values as per format.

No need to include first column which is auto incremented.