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 ```mysql 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

|
60 : 00

Click the virtual machine below to start practicing