Retrieving Records From a Table With Queries in MySQL

MySQL·1 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.

  1. Log in to the MySQL client the root account:

    $ mysql -u root

  2. Once logged in, create a new database named learnbackend:

    CREATE DATABASE learnbackend;

  3. Select the database:

    USE learnbackend;