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
