Introduction
In this project, you will learn how to update a student's GPA (Grade Point Average) in a database using the UPDATE
statement in SQL.
ð Preview
MySQL [edusys]> SELECT * FROM student WHERE name = "Snow";
+-------+------+-----------+----------+
| ID | name | dept_name | tot_cred |
+-------+------+-----------+----------+
| 70557 | Snow | Physics | 61 |
+-------+------+-----------+----------+
1 row in set (0.000 sec)
ðŊ Tasks
In this project, you will learn:
- How to start the MySQL server and log into the MySQL terminal
- How to import a database script into the MySQL database
- How to use the
UPDATE
statement to modify data in a table - How to verify the updated data in the database
ð Achievements
After completing this project, you will be able to:
- Understand the basic SQL
UPDATE
statement and how to use it to modify data in a database - Gain experience in working with MySQL, including starting the server, logging in, and executing SQL scripts
- Develop skills in database management and data manipulation