We're becoming a serious MySQL resource, with many technical articles, examples, forum posts and blog entries answering those difficult-to-resolve issues you may have come across. You might like to bookmark (or link to) this page.

Eleven recent articles on MySQL ...

Flashbulb moments - facts that clarify the "what" and "how" of MySQL

Copying databases and tables

Saving a result set locally for use in a spreadsheet

Setting up and running master and slave servers (replication)

Finding Orphan (unconnected) records in a database

How to translate a requirement to a table design

Complex select example - UNION, HAVING, GROUP etc

Exact, like and fuzzy matching of criteria

A PHP tool for ad-hoc MySQL queries

Joining a table to itself

Summing or averaging a column for each unique value in another column

and some old favourites:

What to do when you have a running system and realise that the design needs an overhaul

The difference between a JOIN and a LEFT JOIN

Uploading, storing and retrieving images in a BLOG

Writing joins of more than two tables

How to design and implement a many-to-many mapping

When to break the rules of normalisation

The vital difference between "Empty" and "Don't Know"

Optimising Selects

Using old client programs (4.0 and prior) on new servers (4.1 and later)

Other MySQL nuggets
(written 2005-12-03 07:34:22)

 H113 - Using MySQL Databases in PHP Pages
P308 - Using SQL Databases from Perl
S151 - Introduction to SQL and MySQL
S152 - SQL Primer as Used in MySQL
S153 - Sourcing, Running and Configuring MySQL
S154 - MySQL - Designing an SQL Database System
S157 - More MySQL Commands
S159 - MySQL 5 and PHP 5
J811 - Java - JDBC - Relational Database Access

Back to Crazy Day-sies

Previous and next or Horse's mouth home

Forward to Open source questions? Anyone can ask.

New Road
Passport office - a much improved system
An occasional chance, and reducing data to manageable levels
Open source questions? Anyone can ask.
MySQL - an FAQ
Crazy Day-sies
MySQL - JOIN or WHERE to link tables correctly?
Exciting futures - the Well House Manor project
Domain Forwarding - 2 ways of doing it
Dynamic Web presence - next generation web site
Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33 at 50 posts per page


This is a page archived from The Horse's Mouth at http://www.wellho.net/horse/ - the diary and writings of Graham Ellis. Every attempt was made to provide current information at the time the page was written, but things do move forward in our business - new software releases, price changes, new techniques. Please check back via our main site for current courses, prices, versions, etc - any mention of a price in "The Horse's Mouth" cannot be taken as an offer to supply at that price.

Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).