Introduction
In this project, you will learn how to access a MySQL database using the sudo
command and write an SQL query to calculate the duration of the Wuxu Reform, also known as the "Hundred Days' Reform".
👀 Preview
MariaDB [(none)]> SOURCE /home/labex/project/wuxu.sql;
+-------------------------+
| Duration of Wuxu Reform |
+-------------------------+
| 103 |
+-------------------------+
1 row in set (0.000 sec)
🎯 Tasks
In this project, you will learn:
- How to start the MySQL service and access the MySQL database using the
sudo
command - How to write an SQL query to calculate the duration of the Wuxu Reform
- How to save the SQL query in a script file and execute it in the MySQL prompt
🏆 Achievements
After completing this project, you will be able to:
- Understand the basics of accessing and interacting with a MySQL database using the command line
- Write SQL queries to perform simple data analysis tasks
- Apply your SQL knowledge to solve real-world problems, such as calculating the duration of historical events