More MySQL Commands

Training, Open Source computer languages

Perl • PHP • Python • MySQL • httpd / Tomcat • Tcl • Ruby • Java • C and C++ • Linux • CSS

Related technical and longer articles

Copying databases and tables in MySQL
MySQL joins - using left join and right join to find orphan rows
MySQL SELECT - JOIN versus UNION, WHERE versus HAVING, GROUP etc.
Left Joins to link three or more tables
When to denormalise your MySQL data
MySQL Extras
Solution Centre - all article listing
Solution Centre - all article listing

Tips and short articles on this subject

Joining MySQL tables revisited - finding nonmatching records, etc
MySQL joins revisited
Outputting numbers as words - MySQL with Perl or PHP
MySQL - the order of clauses and the order of actions
Helicopter views and tartans
Key facts - SQL and MySQL
Saving a MySQL query results to your local disc for Excel
Giving the researcher power over database analysis
Combining similar rows from a MySQL database select
An occasional chance, and reducing data to manageable levels
MySQL - an FAQ
MySQL - JOIN or WHERE to link tables correctly?
SELECT in MySQL - choosing the rows you want
MySQL - a score of things to remember
Matching in MySQL
Getting a list of unique values from a MySQL column
MySQL - Optimising Selects
MySQL - LEFT JOIN and RIGHT JOIN, INNER JOIN and OUTER JOIN

Well House Consultants

You are on the site of Well House Consultants who provide Open Source Training Courses and business hotel accommodation. You are welcome to browse and use our resources subject to our copyright statement and to add in links from your pages to ours.

Other subject areas - resources

Java Resources
Well House Manor Resources
Perl Resources
Python Resources
PHP Resources
Object Orientation and General topics
MySQL Resources
Linux / LAMP / Tomcat Resources
Well House Consultants Resources
Extras Resources
C and C++ Resources
Ruby Resources
Tcl/Tk Resources
Web and Intranet Resources

More MySQL Commands - module S157

This topic is presented on public course MySQL

Examples from our training material

agents	SQL statements for Agent and Property demo
agents.tab	Estate agent details - Trowbridge, Melksham, etc
homes.tab	Houses for sale - Trowbridge, Melksham, etc
perlit	6 tables ordering system model - perl program
rz	6 tables ordering system model - running output
shopper	6 tables ordering system model - Design and test in SQL

Specialist books

Opentalk forum discussions related to this topic

THREE WAY JOINS with subqueries amp groups
A Really easy project but need help
Subtraction one set from anothe set in MySQL
Multiple users and data integrity
Microsoft Excel to Mysql
Loading a table from data in a text file
How to write an INNER JOIN QUERY in Mysql
Foreign Keys steps to enable
Does a table exist Oracle and MySQL check

Background information

Some modules are available for download as a sample of our material or under an Open Training Notes License for free download from http://www.training-notes.co.uk.

Topics covered in this module

Complex joins.
Left, right and straight join.
Aliases.
Optimising queries.
Selection efficiency.
Transactions.
Locking issues.
Commit and rollback.

Complete learning

If you are looking for a complete course and not just a information on a single subject, visit our Listing and schedule page.

Well House Consultants specialise in training courses in Python, Perl, PHP, and MySQL. We run Private Courses throughout the UK (and beyond for longer courses), and Public Courses at our training centre in Melksham, Wiltshire, England. It's surprisingly cost effective to come on our public courses - even if you live in a different country or continent to us.

We have a technical library of over 600 books on the subjects on which we teach. These books are available for reference at our training centre. Also available is the Opentalk Forum for discussion of technical questions.

See also:
"left joins to link three or more tables" in our solution centre
"when to denormalise your data" in our solution centre
"when to denormalise your mysql data" in our solution centre

Public Course Enquiry / Booking

Courses that run regularly at our UK training Centre.
[Schedule] - [About] - [Book]

Other MySQL Modules

S151 - Introduction to SQL and MySQL

S152 - SQL Primer as Used in MySQL

S153 - Sourcing, Running and Configuring MySQL

S154 - Designing an SQL Database System

S156 - Interfacing Applications to MySQL Databases

S157 - More MySQL Commands

S158 - GUI tools for MySQL

S159 - MySQL 5 and PHP 5

S161 - Data Access and Security in MySQL

S162 - Replication in MySQL

© WELL HOUSE CONSULTANTS LTD., 2008: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 707126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho