Difference between revisions of "Select Queries"
Line 2: | Line 2: | ||
* 'Outputs' the data once successfully selected | * 'Outputs' the data once successfully selected | ||
* Allows selection from multiple tables but not multiple databases. | * Allows selection from multiple tables but not multiple databases. | ||
+ | |||
<syntaxhighlight lang=sql> | <syntaxhighlight lang=sql> | ||
SELECT `data` FROM `TABLE`; | SELECT `data` FROM `TABLE`; | ||
</syntaxhighlight> | </syntaxhighlight> |
Revision as of 15:42, 15 December 2016
- Used for fetching information from an SQL database.
- 'Outputs' the data once successfully selected
- Allows selection from multiple tables but not multiple databases.
SELECT `data` FROM `TABLE`;