MySQL is the most popular database. It's an open source Relational Database Management System (RDBMS). MySQL normally is a central component of the LAMP (Linux, Apache, MySQL, PHP/ Python/ Perl) stack; many bundles include MySQL:
- AMPPS (Max, Linux, and Windows) – https://www.ampps.com
- XAMPP (Mac, Linux, and Windows) – https://www.apachefriends.org
- WAMP Server (Windows) – http://www.wampserver.com
- MAMP (Mac) – https://www.mamp.info
Other developers prefer to install it individually. If you want to do this, you can download MySQL directly from the official website: https://dev.mysql.com/downloads/mysql/.
In this recipe, I'm going to use MySQL Workbench to execute the SQL queries. You can download it from https://www.mysql.com/products/workbench/. Feel free to use...