Retrieving Records From a Table With Queries in MySQL

MySQL·2 min read·Jan 1, 2025

Before diving into this lesson and the following ones, you will have to perform some basic setup on your database server.

💡 Tip: Once logged in, you can directly copy the following SQL statements, paste them into the MySQL client interface, and press the ENTER key to execute them.

Log in to the MySQL client the root account:
```
$ mysql -u root
```
Once logged in, create a new database named learnbackend:
```
CREATE DATABASE learnbackend;
```
Select the database:
```
USE learnbackend;
```

Unlock the Build RESTful APIs in Node.js module

Learn how to build real database-backed and framework-powered RESTful APIs with MySQL, Sequelize, and Express.

You get immediate access to:

37 focused lessons across MySQL, Sequelize, backend, and Express
4 real-world projects with commented solutions
Ongoing updates to this bundle
Lifetime access to this bundle

Unlock this module