MySQL is a very commonly used open source relational database. MySQL8 is more rigorous and enhanced security than the previous version. At the same time, MySQL8 has also made many optimizations in performance. This article describes in detail how to install and configure MySQL8 on CentOS7.

If we need to add and subtract dates and times in MySQL, we can use: DATE_ADD, DATE_SUB, ADDDATE, SUBDATE, this article explains the use of these functions in detail.