Mysql选择问题 [英] Mysql select question
问题描述
你好,
我有一个网站上有产品。
该网站有一个mysql后端。
所有产品属于某些系列(餐桌系列)。
最多可以有4种不同的产品(餐桌产品)
(1-4类) 1系列。
每个产品都有一个定义的''系列ID''告诉我们
该产品属于哪个系列。
如果我正在查看cat = 1的所有产品,我怎么知道
是否有cat = 2和/或cat = 3和/或cat = 4同样的
系列ID。这可以在一个查询中完成吗?
谢谢!
任何人?
*请*任何人?
frizzle写道:
< blockquote class =post_quotes> * please * everyone?
答案是可能。
我真的根据您提供的信息,不能说更多。也许
你应该问谁写了mySQL后端。
-
phil [dot] ronan @ virgin [dot] net
http://vzone.virgin.net/phil.ronan/
Hi there,
I have a site with products on it.
The site has a mysql backend.
All products belong to certain series (table series).
There can be up to 4 different products (table products)
(categories 1-4) in 1 series.
Each product has a defined ''series ID'' which tells us
what series the product belongs to.
If i''m viewing all products with cat=1, how do i know if
there is a cat=2 and/or cat=3 and/or cat=4 with the same
series id. Can this be done in 1 query?
Thanks!
anyone?
*please* anyone?
frizzle wrote:
*please* anyone?
The answer is "probably".
I really can''t say much more based on the information you provided. Perhaps
you should ask whoever wrote the mySQL backend.
--
phil [dot] ronan @ virgin [dot] net
http://vzone.virgin.net/phil.ronan/
这篇关于Mysql选择问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!