SET? i know how to use SET but... attribute of products is value such as Size Weight Color and so on the problem is, different CATE of products have different bunch of attribute
>On Tue, 2002-06-18 at 00:53, Xuefer wrote: >> (mailbox full? repost) >> >> I have many product CATE (category) >> and every CATE of products have different attribute >> >> how can I orgnize table struct ? >> >> each CATE a table with many cols for attribute? >> [cateid attr1 attr2 ... ] >> >> or get attribute in one table and each row one attribute >> [produceID attributeID attributeValue ] >> >> or any other ways? > > Hello Xuefer, > > You can use one or more SET type columns to store the properties. > See http://www.mysql.com/doc/S/E/SET.html for more details. > > Good Luck! >-- > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Zak Greant <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate >/_/ /_/\_, /___/\___\_\___/ Calgary, Canada > <___/ www.mysql.com > > >--------------------------------------------------------------------- >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
