Wuxu Reform Duration Calculation

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