=/tmp/mysql.sock
port=3306
myisam-recover=BACKUP,FORCE
log-slow-queries=/usr/local/mysql/data/slow.log
log=/usr/local/mysql/data/mysqld.log
log-bin=/usr/local/mysql/data/binary.log
[mysql.server]
user=sql
basedir=/usr/local/mysql
On Tue, 13 Mar 2001, goEbusiness.com Mail Lists wrote:
> OS: Solaris
OS: Solaris 7, Sparc
MySQL Version: 3.23.29a
Problem:
Sometimes when I do a mysqladmin shutdown on the command line mysql restarts
itself instead of shutting down.
>From the CLI:
elvis~ >mysqladmin -uadmin -pdevsqladmin shutdown
Terminated
010313 18:17:40 mysqld
, Rolf Hopkins wrote:
> Don't know about max number but unlimited, I would have thought.
>
> SELECT b1.foo, b2.foo
> FROM bar as b1, bar as b2
> WHERE ...
>
> Will get you a table join on itself.
>
> - Original Message -----
> From: "goEbusiness.
How many times can I join tables together? What about joining a table to itself?
I checked the maillist archive/manual but cannot find a definite answer (searched on
"max number of joins", "joins")...I'd though it would be in section 7.20 of the manual
but it wasn't.
Thanks.
Bill
-