w3resource logo


php exercises

MySQL Exercises, Practice, Solution

Secondary Nav

What is MySQL?

MySQL is the world's most widely used open-source relational database management system (RDBMS), enabling the cost-effective delivery of reliable, high-performance and scalable Web-based and embedded database applications. It is widely-used as the database component of LAMP (Linux, Apache, MySQL, Perl/PHP/Python) web application software stack.

The best way we learn anything is by practice and exercise questions. We have started this section for those (beginner to intermediate) who are familiar with SQL and MySQL. Hope, these exercises help you to improve your MySQL query skills. Currently following sections are available, we are working hard to add more exercises. Happy Coding!

Exercises on Data Manipulation Language (DML) & Data Definition Language (DDL)

Exercises on HR Database

Exercises on Northwind Database

More to Come !

Structure of 'hr' database :

hr database

You may download the structure and data of the database used here

 

Structure of 'northwind' database :

mysql northwind database

You may download the structure and data of the database used here



Join our Question Answer community to learn and share your programming knowledge.

Solve these problems:

Python: How to call an external command in Python?

C#: Loops in c#

SQL: JOIN using more than 5 tables