So far we've covered enough to let you create a basic table in a database and to insert data into that basic table. The next and most interesting step to working with database is querying that data.

In order to retreive data from our database, we 'query' for records using the 'SELECT' command.

Let's start with grabbing all of the data from a table using a 'wildcard'.

If we want to query all the data from our 'Users' table- we would run this command:

SELECT * FROM Users;

The is a wildcard. It means "Everything". So we're selecting all the columns from Users.

Instead of a 'wildcard' using an asterisk, we can specific columns from a table by replacing our wildcard with the column names that we want, seperated by commas.

SELECT id,name FROM Users;

In our db-fiddle example, you can write the "Query" in the 'Query SQL' box to test this:

0 Comments

Top comments

"Please login to view comments"

Join the Conversation!

Subscribing gives you access to the comments so you can share your ideas, ask questions, and connect with others.

Upgrade your account