Re: by char partitioning

[Jonathan Stephens]

A better design practise would be to create a shops table like this one:

CREATE TABLE shops (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name CHAR(20) NOT NULL
);

Then use the shops.id values in the SHOP column of the hist table.

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle