Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact

New telephone system - working a day early.
01225 708225 (phone) and 01225 899360 (fax) again ;-)
Upcoming U.K. MySQL courses ...
MySQL

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
Removing duplicates from a MySQL table
Optimising and caching your MySQL enquiries
Counting rows in joined MySQL tables
Relating tables with joins in MySQL
MySQL - efficiency and other topics
Grouping rows for a summary report - MySQL and PHP
MySQL - looking for records in one table that do NOT correspond to records in another table
Ruby, Perl, Linux, MySQL - some training notes
Finding words and work boundaries (MySQL, Perl, PHP)
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
MySQL module S157
More MySQL Commands
Exercises, examples and other material relating to training module S157. This topic is presented on public course MySQL

In a database such as MySQL, data is divided into a series of tables (the "why" is beyond what I'm writing today) which are then connected together in ...
http://www.wellho.net/mouth/158_MySQ ... -JOIN.html  [short article]
div class= introsubheads MANY-TABLE JOINS IN MYSQL - BACKGROUND BR /div Data held in SQL tables should be b normalised /b - in other words, held ...
http://www.wellho.net/solutions/mysql-le ... ables.html  [longer article]
Would you like to get a list of all the different values in a column? Use the DISTINCT keyword. Here's an example: mysql> select * from train; +-------+--------+-------------+-----+ ...
http://www.wellho.net/mouth/279_Gett ... olumn.html  [short article]
The MySQL Relational database - Structure, Installation, Administration, Database Design and Programming through SQL This course introduces you to the ...
http://www.wellho.net/course/mqfull.html  [course]
div class= introsubheads OPTIONAL CLAUSES TO SELECT BR /div In MySQL, the simplest of SELECT commands sends the whole contents of a table to the ...
http://www.wellho.net/solutions/mysql-my ... p-etc.html  [longer article]
If you re joining several tables together, you can do so in such a way that you show only the combined results, or in such a way that you can also (or ...
http://www.wellho.net/solutions/mysql-my ... -rows.html  [longer article]
This page is the answer to questions like can I save the results from a query into a table of its own ... but before we you start, ask yourself the ...
http://www.wellho.net/solutions/mysql-co ... mysql.html  [longer article]
MySQL tables can be joined using two different syntaxes - one that simply lists the tables to be joined and then uses a where clause to select how the ...
http://www.wellho.net/mouth/513_MySQ ... ctly-.html  [short article]



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
seeder   Data for join v left join demonstration
shopper   6 tables ordering system model - Design and test in SQL
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
Revision.
Complex joins.
Left right and straight join.
Aliases.
Inner and outer joins.
Indexes.
Unique and regular indexes.
Multiple field indexes.
Fulltext indexes.
Optimising queries.
Join order and what to index.
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 700 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.


You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2010: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 0800 043 8225 or 01225 708225 • FAX: 01225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho