McGoo_Query - MySQL Query Engine

SQL:

SQL:

Output:	SQL SELECT statements only please. All other SQL statements will not work here. 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. In LIKE statements, MySQL uses: the percent sign(%) and the underscore sign (_) as the wildcards not asterix(*) & question mark(?) as in MS Access SQL. Use the View HTML button to view, select and copy the SQL output as HTML. Download a template to paste you answers into. (Right-click - Save Link/Target As...)

Output:

SQL SELECT statements only please. All other SQL statements will not work here.
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.
In LIKE statements, MySQL uses:

the percent sign(%) and the underscore sign (_) as the wildcards

not asterix(*) & question mark(?) as in MS Access SQL.
Use the View HTML button to view, select and copy the SQL output as HTML.
Download a template to paste you answers into. (Right-click - Save Link/Target As...)

McGoo_Query is provided as a service to schools offering studies into the use of Structured Query Language. This application uses a MySQL database, thus the appropriate syntax for using this service is that of MySQL.

The application was originally 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