I am not very sure I understand the question....but maybe column type 'enum' is what you are looking for. ----- Original Message ----- From: "david" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 10, 2002 9:43 PM Subject: MySQL database design, one column, 10 entries?
> > I am creating several tables in MySQL and linking via primary keys. I am held > up on one issue, for one row in one table i have a column 'favorites' where i > want to hold up to 10 unique entries, how do i implement this? > > > userTable > userId varchar(20) > name varchar(30) > email varchar(40) > > preferences > userId varchar(20) > styles varchar(20) > favorites ???????? > > > preferences > userId styles favorites rating > 01 'modern' '#1 sleek' 15 > '#2 ultra-sleek' 20 > '#3 un-sleek' 12 > '#4 plain' 9 > etc, up to 10 or so. > > 02 'gothic' '#1 dark' 21 > '#2 tall' 4 > '#3 scary' 2 > etc, etc,... > I can't just make it a really long varchar(1000) because of the other columns > that act on the same data. I hope that this is an appropriate question for > this MySQL list. > TIA > > -david > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php