MySQL Forums
Forum List  »  Partitioning

Re: by char partitioning
Posted by: Jonathan Stephens
Date: June 25, 2007 06:33AM

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
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
3816
June 25, 2007 03:59AM
Re: by char partitioning
2571
June 25, 2007 06:33AM
2580
June 25, 2007 07:05AM
2537
June 25, 2007 09:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.