Querying Data

This lesson teaches how to query for data in MySQL.

We'll cover the following

Querying Data

In this lesson we’ll learn how to query the data we have stored in a table. The SELECT statement allows us to retrieve data from tables.

Example Syntax

SELECT col1, col2, … coln

FROM table

WHERE <condition>

Connect to the terminal below by clicking in the widget. Once connected, the command line prompt will show up. Enter or copy and paste the command ./DataJek/Lessons/8lesson.sh and wait for the MySQL prompt to start-up.

Level up your interview prep. Join Educative to access 70+ hands-on prep courses.