Introduction
In this project, you will learn how to add student personal information to a database. You will start by learning how to set up the MySQL server and import the necessary database. Then, you will create a SQL script to insert new student records into the student
table.
👀 Preview
MariaDB [edusys]> SELECT * FROM student WHERE ID = 93521 OR ID = 89212;
+-------+------+-----------+----------+
| ID | name | dept_name | tot_cred |
+-------+------+-----------+----------+
| 89212 | Tang | Music | 60 |
| 93521 | Rong | History | 68 |
+-------+------+-----------+----------+
2 rows in set (0.000 sec)
🎯 Tasks
In this project, you will learn:
- How to start the MySQL server
- How to import a database using SQL scripts
- How to use SQL
INSERT
statements to add new data to a table
🏆 Achievements
After completing this project, you will be able to:
- Set up a MySQL server and import a database
- Write SQL scripts to insert new data into a database table
- Verify the inserted data using SQL queries