Add Student Personal Information

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