Difference between revisions of "Select Queries"

From TRCCompSci - AQA Computer Science
Jump to: navigation, search
(Created page with "* Used for fetching information from an SQL database. * 'Outputs' the data once successfully selected * Allows selection from multiple tables but not multiple databases. :Ind...")
 
Line 3: Line 3:
 
* Allows selection from multiple tables but not multiple databases.
 
* Allows selection from multiple tables but not multiple databases.
  
:Indented line "SELECT `data` FROM `TABLE`
+
        "SELECT `data` FROM `TABLE`;

Revision as of 11:12, 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`;