MySQL:Interactive Help Desk

Instructions
On this page you can post some MySQL code that you are having trouble with.
 * Please keep the code "simple" concentrating on the problem ... not a lot of code with a "small" problem.
 * Post a tweet including the #vmvwiki tag so that we know there is a problem waiting to be solved.
 * Paste the following wiki code when you edit, and put your code where shown.

Posting reward scheme
The rules here are:
 * if it is a complex problem, and you solve it you should be rewarded with a small choc from the person posting, however
 * if it is easy to solve a more substantial chocolate "gift" (like a large chocolate fish would be nice :)

Problem 1: UPDATE not working
one.sql

This causes a MySQL Error...