Inserting Records

In this post, I will focus on inserting records into the tables made during the I Break Code's Creating Tables post. During we created two tables Authors and Books. The Authors table has three columns: author_ID, first_Name; last_Name. The Books table has five columns: book_ID, title, genre; description.

We are going to insert two records into our authors table:

Author 1:
First name: Geoffrey
Last name: Chaucer

Author 2:
First name: William
Last Name: Shakespeare

1. USE Library;
2. GO
4. INSERT INTO Authors
5. (
6.     first_Name
7.     , last_Name
8. )
9. VALUES
10. (
11.     ' Geoffrey'
12.     , 'Chaucer'
13. );
15. INSERT INTO Authors
16. (
17.     first_Name
18.     , last_Name
19. )
20. VALUES
21. (
22.     ' William'
23.     , 'Shakespeare'
24. );

When executed, this query will insert two authors into our "Authors" table with the provided information.

Now, let's add some books to our "Books" table.

Book 1:
Title: The Cantebury Tales
Genre: Classic/Poetry
Description: A great collection of poems and stories.

Book 2:
Title: Macbeth
Genre: Classic/Play
Description: "Fair is foul, and foul is fair". - ( Quote Act I, Scene I).

1. USE Library;
2. GO
4. INSERT INTO Books
5. (
6.     title
7.     , genre
8.     , [description]
9. )
10. VALUES
11. (
12.     'The Cantebury Tales'
13.     , 'Classic/Poetry'
14.     , 'A great collection of poems and stories.'
15. );
17. INSERT INTO Books
18. (
19.     title
20.     , genre
21.     , [description]
22. )
23. VALUES
24. (
25.     'Macbeth'
26.     , 'Classic/Play'
27.     , '"Fair is foul, and foul is fair". - ( Quote Act I, Scene I).'
28. );

When executed, this query will insert two books into our "Books" table with the provided information.