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
