More MySQL Commands

MySQL module S157

More MySQL Commands

Exercises, examples and other material relating to training module S157. This topic is presented on public course MySQL

MySQL - LEFT JOIN and RIGHT JOIN, INNER JOIN and OUTER JOIN

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]

Left Joins to link three or more tables

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]

Getting a list of unique values from a MySQL column

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 - training course - Structure, Installation, Administration, Database Design and Programming through SQL

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]

MySQL SELECT - JOIN versus UNION, WHERE versus HAVING, GROUP etc.

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]

MySQL joins - using left join and right join to find orphan rows

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]

Copying databases and tables in MySQL

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 - JOIN or WHERE to link tables correctly?

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.