bubble_chart StackLab

Database Migration

19 steps · pending Not started · person_outline Guest
arrow_back Back

Add some sample students

Our tables are ready, but they are empty. Let's add a few students that we can use for testing. Add this to the migration:

code sql
INSERT INTO students (
    student_first_name,
    student_last_name,
    student_course
) VALUES
    ('CLIFF AMADEUS', 'EVANGELIO', 'BSIT'),
    ('JAN XAVIER', 'EVANGELIO', 'BSA-AGRONOMY'),
    ('RON EDMUND', 'EVANGELIO', 'BSEE'),
    ('RK', 'FERNANDEZ', 'BSIT');
These records are called seed data.
code text
ID        | First Name      | Last Name     | Course
------------------------------------------------------------
1         | CLIFF AMADEUS   | EVANGELIO     | BSIT 
2         | JAN XAVIER      | EVANGELIO     | BSA-AGRONOMY
3         | RON EDMUND      | EVANGELIO     | BSEE
4         | RK              | FERNANDEZ     | BSIT
Seed data gives us something to work with while developing and testing the application.

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