Exercises, examples and other material relating to training module S050. This module is presented on Private Courses and Specially Run Courses only

---

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]

The future of MySQL MySQL has grown from a very neat little open source database 10 years ago into a very powerful and widespread database that's not always fully open source ... http://www.wellho.net/mouth/2561_The ... MySQL.html  [short article]

Which version of MySQL am I running? Oh be careful - that is a VERY dangerous question. Do you mean "what version is my MySQL server" or "what version of the mysql client program am I running?" ... http://www.wellho.net/mouth/2426_Whi ... ning-.html  [short article]

What a difference a MySQL Index made If you add an index to a column in a MySQL table, you provide a very quick way of looking up a row or set of rows based on the value in a certain column, ... http://www.wellho.net/mouth/2053_Wha ... -made.html  [short article]

Management overview of MySQL - background and Philosophies This morning, I listened to David Axmark from Sweden and Monty Widenius from Finland talk about their MySQL Database engine. div class= introsubheads ... http://www.wellho.net/solutions/mysql-ma ... phies.html  [longer article]

Moving the product forward - ours, and MySQL, Perl, PHP and Python too I have just posted a "steady as she goes" message, welcoming the new decade but reassuring our customers that we're carrying on offering very much the ... http://www.wellho.net/mouth/2559_Mov ... n-too.html  [short article]

Oracle take over Sun who had taken over MySQL The newspaper tells me that Oracle is buying Sun Microsystems. Since Sun Microsystems bought MySQL about a year ago, this means that Oracle now owns MySQL. ... http://www.wellho.net/mouth/2134_Ora ... MySQL.html  [short article]

---

MySQL is a relational database system - a system that's used for updating and extracting data from a series of linked tables so that the data can be stored uniquely, efficiently, and without conflict when several users require concurrent access.

This module is presented on Private Courses and Specially Run Courses only

sample_mysql_table

Create a table with duplicate records to remove as an exersize