Lesson 9 - MySQL Step By Step: Exercises to practise
In the previous lesson, MySQL Step By Step: More Queries And the M:N Relationship, we learned the M:N relationship, use
JOINs, and we created a new
We won't learn anything new today, we're going to practice the knowledge we've
gained. We're going to come up with 10 different sample queries.
To learn something, reduce the height of your browser window so that you don't see the resulting query, but just the task description. Try to figure out the query on your own and then check it with the result.
Let's do it!
Example 1: Select the comments (their content and creation date) in the second quarter of 2012, sorted by date.
SELECT `content`, `created` FROM `comment` WHERE `created` BETWEEN '2012-3-1' AND '2012-6-30' ORDER BY `created`;
Great article! 2012-04-06 00:00:00 Good game! 2012-04-06 00:00:00 I died and... 2012-04-14 00:00:00 Great article in deed! 2012-05-06 00:00:00
...End of the preview...
You've come here and that's great! We believe that the first lessons showed you something new and useful
Do you want to continue the course? Go to the premium section.
- Unlimited and permanent access to individual lessons.
- High quality IT knowledge.
- Skills to help you get your dream and well-paid job.
Requested article covers this content:
In this tutorial, we'll give you several exercises you can try to run on a MySQL database to practice and check the results with yours.
You gain points by supporting our network. This is done by sending a helpful amount of money to support the site, or by creating content for the network.