bubble_chart StackLab

Database Migration

19 steps · pending Not started · person_outline Guest
arrow_back Back

Verify that the migration worked

Let's make sure everything was created correctly. Select the database:

code sql
USE library_db;
Now list the tables:
code sql
SHOW TABLES;
You should see:
code text
borrow
books
students

Check the students

code sql
SELECT * FROM students;

Check the books

code sql
SELECT * FROM books;

Check the borrowing records

code sql
SELECT * FROM borrow;

Checkpoint

If all three tables contain the expected records, your migration has been successfully applied.

login Sign in to save your progress permanently. info Progress is saved in your browser session
format_list_numbered Step 13 of 19