Hello all. I'm looking for help with the query below. Is there anyway
to prevent the temporary and filesort? I've tried about as many
combinations as I could think of, but can't seem to prevent it. I'm
sure that's the reason, when run on a table of around 750k records, it
takes in excess of 20 s
will return both the matching recs from the user table and NULLs from
the person table in sql server, but is what I cant get to work in mysql...
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 19, 2005 3:14 PM
To: Rich Brant
Cc: mysql@lists.mysql.com
I'm used to doing something simple such as the following in sql server:
SELECT u.Username, p.UserID
FROM Users u LEFT JOIN
Person p ON u.UserID = p.UserID
However, I'm not seeing the same results in MySQL. I don't get all
the recs in the users table and NULLs in the userID c
Hi all,
I have a bunch of tables I need to create on a remote database. The
backup files are all in one folder. They are .frm,.myd and.myi files.
1. Do these files need to be on the remote server in order to be used
as to create the table?
2. Looking at the user docs on myslq, it appears I need
Ok, Thanks Tobias! I'm all set. And I actually found the relevant info in
the manual. Sorry for the bother, all.
From: Tobias Asplund <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: "'Rich Brant'" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject:
gt;
Reply-To: <[EMAIL PROTECTED]>
To: "'Rich Brant'" <[EMAIL PROTECTED]>
CC: <[EMAIL PROTECTED]>
Subject: RE: my.ini file for two instances of MySql - need help
Date: Mon, 12 Jan 2004 10:55:21 -0600
Here is an example of what I used:
[mysqld]
# set basedir to your
Hello,
I need to get two instances of Mysql running on the same machine. It's a
windows 2000 server. The existing MySQL is 3.23 and is running in another
directory. It appears to be used for LiveStats.
I need to install version 4 and have them both running.
What do I need to add to the my.in
