SQL:

Output:



  1. SQL SELECT statements only please. All other SQL statements will not work here.
  2. Please use double quotes, not single quotes, to show strings in queries
    Use: Select * from Movies where movname = "Fool's Gold"
    Not: Select * from Movies where movname = 'Fool's Gold'
    This prevents problems with names that include apostrophes.
  3. In LIKE statements, MySQL uses:
    the percent sign(%) and the underscore sign (_) as the wildcards
    not asterix(*) & question mark(?) as in MS Access SQL.
  4. Use the View HTML button to view, select and copy the SQL output as HTML.
  5. Download a template to paste you answers into. (Right-click - Save Link/Target As...)
McGoo

McGoo_Query is provided as a service to Queensland schools offering the Queensland Curriculum and Assessment Authority subject, Information Processing and Technology.

The application is intended to be used to accompany textbook exercises from works such as Leading Technology by Kevin Savage. A number of the accompanying databases, including School, Movies, Repairs and Pms, are sourced from Kevin's work.

The Egypt database is originally from an ancient textbook by Offer and Thompson.
The Shares database comes from a very early edition of Borland Delphi.
The World database is an open-source resource provided at dev.mysql.com

McGoo uses and recommends the very useful tutorials found at:

W3Schools - Free HTML, CSS, JavaScript, PHP, SQL tutorials with lots of working examples and source code.

This software uses the following technologies:

SQL - Structured Query Language
MySQL DBMS - DataDase Management Service
PHP - PHP Hypertext Preprocessor
HTML - HyperText Markup Language and CSS - Cascading Style Sheets
Javascript - Browser Scripting Language using AJAX - Asynchronous Javascript and XML via the Prototype Library
HTML DOM - HTML Document Object Model