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
3859
June 25, 2007 03:59AM
Re: by char partitioning
2608
June 25, 2007 06:33AM
2612
June 25, 2007 07:05AM
2563
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.