Learn SQL Database Programming

Multiple row inserts

To insert multiple rows into a table in MySQL, use the following query:

USE lahmansbaseballdb;INSERT INTO collegeplaying(playerID, schoolID, yearID)VALUES ('blaloha01','sandiegost',2000),    ('blaloha01','sandiegost',2001),    ('blaloha01','sandiegost',2002);

You will see the following results from the previous query. It shows that your INSERT statement worked by inserting three rows into the collegeplaying table for the playerID blaloha01, it shows that this player attended sandiegost State University in 2000, 2001, and 2002:

In the previous screenshot, you can see the results from the collegeplaying table for playerID the ...