Below I have listed the most common commands that I am using when acquiring data from a database
Selecting a single Column from a table:
SELECT name
FROM people;
This will select the column "Name" from the "People" Table.
Selecting multiple columns from a table:
SELECT name, birthdate
FROM people;
This will select the Name and Birthrate column from the people table.
SELECT *
FROM people;
This will select all columns from a table.
SELECT *
FROM people
LIMIT 10;
This will select 10 rows with all columns from a table.