yeah, mysql is compatible for small business with small and simple database.
We can use PostgreSQL for subselect query as a free SQL server, but it's too
slow.
-
Before posting, please check:
http://www.mysql.com/manual.php
Nguyen Trong Phuc wrote:
> we can use subselect now with MySQL-Max version.
I think not. I know it failed with 3.23.43, when I tried it just now
(mysqld-max).
Regarding encrypt(), the manual does say that encrypt() returns NULL on
OSes where the crypt() function is not available. True. Howe
ED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, November 10, 2001 10:08 AM
Subject: Re: Beginner SQL Question
> Steve Meyers wrote:
>
> > There are no subselects in MySQL (yet). However, they're usually a bad
> > idea anyway, which is why it's never been such a big rush t
we can use subselect now with MySQL-Max version.
- Original Message -
From: "Steve Meyers" <[EMAIL PROTECTED]>
To: "John Morton" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, November 10, 2001 8:13 AM
Subject: Re: Beginner SQL Question
Steve Meyers wrote:
> There are no subselects in MySQL (yet). However, they're usually a bad
> idea anyway, which is why it's never been such a big rush to get them in.
Sometimes (just sometimes), there is no way to do it except with a subselect.
For instance, we have a table where we get re
NOt supported... Yet. Rumor has it sub-selects will be in 4.1
John Morton wrote:
>
> Hi,
>
> Can someone tell me why this will not work, please
>
> SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn =
> 15);
>
> (Table and column names changed to protect the innocent, "15"
On Sat, 2001-11-10 at 05:53, John Morton wrote:
> Hi,
>
> Can someone tell me why this will not work, please
>
> SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn =
> 15);
>
There are no subselects in MySQL (yet). However, they're usually a bad
idea anyway, which is why it'
John Morton writes:
> Can someone tell me why this will not work, please
>
> SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn =
> 15);
That's a subselect, and a search in the manual gave me this
page, which probably has all the info you need:
http://www.mysql.com/doc/A/N/A
