Difference between revisions of "Select Queries"

From TRCCompSci - AQA Computer Science
Jump to: navigation, search
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 16: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`;