IPT home IPT A Virtual Approach by Peter Whitehouse
Quick Links:
SQL home
Information and Intelligent Systems Social and Ethical Implications Human Computer Interaction Software and Systems Engineering eXercise Files Course Outline and Assessment A-Z of Geeky Acronyms Terrace Work Program 2004 Sillybus FAQ = Frequently Asked Questions Help

MySQL Dictionary

9th Edition (covering MySQL Version 4)

:: Intro :: Datatypes :: DDL :: DML :: Operators :: Built-ins ::


MySQL is a multi-user, multi-threaded, entry-level SQL92, ODBC levels 0-3.51 database server designed to manage relational databases via networks and the Internet. It is open-source (ie. you can investigate what it does, how and if you don't like it, you can modify it to suit your own needs) and designed to manage large databases. MySQL offers a number of the commands available in SQL proper, along with a number that are peculiar to it :- hence the need for this ONLINE DICTIONARY.

MySQL is developed and distributed by MySQL AB as the sole owner of the MySQL server source code, the MySQL trademark and the mysql.com domain worldwide. You can view more about this teriffic product from their website.

DISCLAIMER: Any mistokes or omissons are exactly that (....the albatross did not signify)

This dictionary system retains copyright, and cannot be distributed in any form without direct permission from the author:

    © Copyright 1995..2006 - P. R. Whitehouse

    'The needs of the many outweigh the needs of the one'.

Suggestions for refinement and addition are welcome, as are all constructively critical comments regarding layout, indexing and ease of use of this system.


A number of syntax (grammar) description conventions have been adopted namely:

[....] square brackets indicate optional clauses (ie. bits that can be left out) - you don't type the brackets!
{....} braces (curly brackets) indicate clauses
that can be repeated 0..many times
/ (slash) indicates options (eg. this/that)
CAPITALS have been used to indentify MySQL KEYWORDS. You do not need to type them in uppercase.

Thus the sequence (syntax definition):

Fred [likes eating] { carrots/broccoli/spinach }

can be legally interpreted as any of the following:

  • Fred
  • Fred carrots carrots
  • Fred likes eating
  • Fred likes eating broccoli spinach carrots
You must assume that all other characters are to be typed AS IS!

:: Intro :: Datatypes :: DDL :: DML :: Operators :: Built-ins ::


©Copyright t 1992..2018+. Edition 26.150117
Creative Commons License
This work is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 2.1 Australia License