A reader has just pointed out an improvement to my most recent article

On page 2, you can of course use:

CREATE TEMPORARY TABLE bad_temp AS SELECT DISTINCT * FROM bad_table

instead of:

CREATE TEMPORARY TABLE
bad_temp(id INT,name VARCHAR(20))
TYPE=HEAP;

INSERT INTO bad_temp(id,name) SELECT DISTINCT id,name FROM bad_table;

saving yourself doing it in two steps.

Thanks to P-A Fredriksson. Hopefully the changes will reflect on the site soon.