php3-list | 199807

Re: [PHP3] SQL Question From: Justin Foster (jfoster <email protected>)
Date: 07/31/98

Actually I am using MS Access and I am not sure if it supports sub-selects on
not. Does anyone know?

Sorry for the lack of info, it has been a long day. Thanks for the help.

Michael J. Miller Jr. wrote:

> On Sat, 1 Aug 1998, Tony Hall wrote:
>
> >
> > Depends on the Database you are Writing to
> > e.g, mSQL and mySQL do not support SELECT INTO
> > where as Oracle DOES
>
> Actually MySQL does support SELECT INTO, for files anyway...
>
> SYNOPSIS:
>
> SELECT [STRAIGHT_JOIN] [DISTINCT | ALL] select_expression,... [INTO OUTFILE
> 'file_name' ...] [ FROM tables...]
>
> It doesn't support sub-selects yet though.
>
> -
> Mike Miller mke @ netcom.com
> Maintainer of the MySQL Documentation Project and Web Pages.
> See: http://www.turbolift.com/mysql and http://www.tcx.se for more details.
> Home Page: http://www.turbolift.com/mke 

--
Justin Foster <jfoster <email protected>>

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3