No edit summary |
No edit summary |
||
| Line 7: | Line 7: | ||
FROM people; | FROM people; | ||
</nowiki> | </nowiki> | ||
Selecting multiple columns from a table: | Selecting multiple columns from a table: | ||
| Line 15: | Line 14: | ||
FROM people; | FROM people; | ||
</nowiki> | </nowiki> | ||
<nowiki> | <nowiki> | ||
| Line 22: | Line 20: | ||
FROM people; | FROM people; | ||
</nowiki> | </nowiki> | ||
<nowiki> | <nowiki> | ||
| Line 30: | Line 27: | ||
LIMIT 10; | LIMIT 10; | ||
</nowiki> | </nowiki> | ||
<nowiki> | <nowiki> | ||
Revision as of 02:14, 12 September 2023
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:
This will select the column "Name" from the "People" Table. SELECT name FROM people;
Selecting multiple columns from a table:
This will select the Name and Birthrate column from the people table. SELECT name, birthdate FROM people;
This will select all columns from a table. SELECT * FROM people;
This will select 10 rows with all columns from a table. SELECT * FROM people LIMIT 10;
This will select 10 rows with all columns from a table. SELECT * FROM people LIMIT 10;