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

---

Example - PHP form, Image upload. Store in MySQL database. Retrieve. div class= introsubheads USING PHP AND MYSQL TO PROVIDE AN IMAGE LIBRARY BR /div I m often asked if MySQL can be used to store images - in other words ... http://www.wellho.net/solutions/php-exam ... rieve.html  [longer 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]

Display an image from a MySQL database in a web page via PHP There's lots of clever scripts around to tell you how to get images in and out of databases, but nothing simple to show you the principles of including ... http://www.wellho.net/mouth/937_Disp ... a-PHP.html  [short article]

Many to many table mapping (Pivot tables) In a well designed SQL table, you should design each row to contain consistent and non-repetitive information, and you should avoid having whole lists ... http://www.wellho.net/solutions/mysql-ma ... ables.html  [longer article]

MySQL - Pivot tables If at all possible, you should normalise information in your database using Codd's principles of database normalisation. Basically, this means that you ... http://www.wellho.net/mouth/59_MySQL ... ables.html  [short article]

MySQL - an FAQ We're becoming a serious MySQL resource, with many technical articles, examples, forum posts and blog entries answering those difficult-to-resolve issues ... http://www.wellho.net/mouth/515_MySQL-an-FAQ.html  [short article]

More HowTo diagrams - MySQL, Tomcat and Java Here are some more diagrams "off the wall" from last week - showing "howto" and "whatis" information for Tomcat, Java and MySQL Some Tomcat and Java ... http://www.wellho.net/mouth/1771_Mor ... -Java.html  [short article]

---

Data will be at the heart of your applications. Whilst it is possible to alter data structures later on without losing data, it is much better to get your design right at the start. This module covers the principles of analysing your database-destined data and designing a good structure for it.

This topic is presented on public course MySQL

authors.tab	Author table
books.tab	Book table
docdata.sql	Data for design / complex join example
docjoin.sql	Select for design / complex join example
docs.sql	Database and table setup for design / complex join example
just.php	Skeleton application - design / complex join example
pivot.sql	SQL to load book, author and pivot tables
pivots.tab	Pivot table
sql	Table Design - Restaurants / Category / Line item
tabled.php	Display normalised MySQL tables on a web page

We offer MySQL courses as well ...