Simple Use Case of SQL

SQL Select is the most common and used function in managing databases.

As an example, let's say that we want to display ALL FIELDS in our database.

To do this we can:

SELECT [fields] FROM [table];

SELECT * FROM users;

This query will return ALL FIELDS & RECORDS from the table!

Selecting specific fields

SELECT [field1,field2,etc] FROM [table];

SELECT id,username FROM users;