From: Peter Brawley
>I'd like to run a query to find the records that
>are present in one database but not the other.
See 'Compare data in two tables' at
http://www.artfulsoftware.com/infotree/queries.php.
Thanks. That's a start.
SELECT
MIN(TableName) as TableName, id, col1, col2, col3,
I have two different databases on the same 5.0 server that have the same
tables and structure. They also have very nearly the same data. For one
of the tables I'd like to run a query to find the records that are present
in one database but not the other. Is this possible and what would such a
Doh... found it.
Why are the 'without installer' versions significantly larger than those
with the installer? I would expect it to be the other way around?
- Original Message -
From: "James Eaton" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, July 17, 2007 3:2
Is there a 64 bit build of MySQL 5.0 available for Windows Server 2003 64
bit edition?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a database with roughly the following structure:
album
--
albumid INT
title VARCHAR(255)
artist
--
artistidINT
nameVARCHAR(255)
albumartist
--
albumid INT
artistidINT
From the above, y
- Original Message -
From: "Bruce Dembecki" <[EMAIL PROTECTED]>
To:
Cc: "Ow Mun Heng" <[EMAIL PROTECTED]>
Sent: Monday, October 09, 2006 3:13 PM
Subject: Re: InnoDB, 1 file per table or 1 BIG table?
There are some minor performance benefits here when run against
benchmarks... but tin
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Ow Mun Heng" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, October 09, 2006 9:12 AM
Subject: Re: InnoDB, 1 file per table or 1 BIG table?
In the last episode (Oct 09), Ow Mun Heng said:
Just wanted to know if it would be faster
If I have the following strings in a varchar column:
Piano Sonata 1 - Brendel
Piano Sonata 10 - Brendel
Piano Sonata 11 - Brendel
Piano Sonata 12 - Brendel
Piano Sonata 13 - Brendel
Piano Sonata 14 - Brendel
Piano Sonata 15 - Brendel
Piano Sonata 16 - Brendel
Piano Sonata 17 - Brendel
Piano Sonat
I have a legacy app that only supports MySQL 3.23. I'd like to run it
along with 5.0.24a on a Windows 2000 server, with each instance using the
standard port 3306. So I need to have each instance bound to just one IP
address.
In MySQL 3.23 can you specify a bind-address in the my.ini file, o
bind-address of 127.0.0.1, which I'd removed, but since the MySQL server
wasn't actually being restarted, the new configuration was never picked
up.
- Original Message -
From: "Dan Buettner" <[EMAIL PROTECTED]>
To: "James Eaton" <[EMAIL PROTECTED]>
ected to localhost.
Escape character is '^]'.
A
5.0.21-standard-log&6{-kS?!,$2lMx:Ty%I!d
(I then pressed return and the connection closed)
I can telnet to MySQL from the localhost, but not from any other location.
On 8/23/06, James Eaton <[EMAIL PROTECTED]> wrote:
Is
Is there a way to query a MySQL (5.0.xx) server to find out which IP
address(es) it's listening on? It should be listening on all, but I'm
unable to connect from remote machines, so need to troubleshoot a bit.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
- Original Message -
From: "Nicolas Verhaeghe" <[EMAIL PROTECTED]>
To: "'MySQL General'"
Sent: Saturday, April 15, 2006 11:20 PM
Subject: Should we petition GoDaddy?
I am slowly considering leaving GoDaddy, who has a very good bandwidth
and
ok tech support (I have seen better but muc
13 matches
Mail list logo
