[NTLUG:Discuss] MYSql vs. postgresql
MadHat
madhat at unspecific.com
Sat Feb 22 09:45:43 CST 2003
On Fri, 2003-02-21 at 17:56, Terry Hancock wrote:
> On Friday 21 February 2003 09:41 am, Paul Ingendorf wrote:
> > Quoting David <david at hayes-family.org>:
> > > * sub-queries, such as: SELECT * FROM SALES WHERE ITEM_COLOR IS IN
> > > (SELECT COLOR FROM ....). To do this in Mysql, you need to run
> > > multiple queries and tie them together in your PHP or Perl script.
> >
> > I have always dealt with this using
> > select * from sales,otherdb where sales.item_color = otherdb.color
> > (Comming soon)
> > http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
>
> Coming soon? Doesn't that work in v3.23? Maybe I'm missing a subtlety here,
> but I think I have code like this in my current project somewhere. This is
> really just an implicit join, isn't it?
Heis saying that is what he dones now. the 'real' sub selects are
'coming soon' check the page. ;) Yes, the first method has been
supported for a while.
--
MadHat at Unspecific.com
`But I don't want to go among mad people,' Alice remarked.
`Oh, you can't help that,' said the Cat: `we're all mad here...'
-- Lewis Carroll - _Alice's_Adventures_in_Wonderland_
More information about the Discuss
mailing list