Difficulty: Beginner
Estimated Time: 10 minutes

Learning SQL

Now you're learning mysql!

Learning SQL

Step 1 of 2

Setting up the Environment

Welcome! It may take a while to install and configure the mysql server, so you might want to grab a cup of coffee before you start.

But, once everything finishes, you can get to a command prompt with this statement:

mysql --user=admin

You should now be in the MySQL client. Try typing this:

show databases;

You'll see a list like this:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

We'll be working with the sakila sample data, so let's use that:

use sakila;

OK, now that everything is set, let's get into some SQL!