Viewing Data with SELECT

Now that we have a table, let’s see what’s in it. The SELECT command retrieves data from your table.

View All Data

SELECT * FROM users;

What this does:

• SELECT * = get all fields from the table
• FROM users = from the users table

What You’ll See

After creating your table, SELECT * FROM users; will return no results because the table is empty. In Workbench, you’ll see the column names and no rows.

The table exists but has no data yet. Let’s add some data next.