We're currently running mysql ver 3.23 with plans to upgrade to 4.x soon
but we're not ready yet.
I have two tables that are identical, table1 and table1_old. Table1_old
contains all data writen to table1 prior to july of 2003.
I need to do a single query that pulls the same fields from both
Solutions
+27 82 857 2391
[EMAIL PROTECTED]
There are 10 kinds of people in this world,
those who understand binary and those who don't (Unknown)
- Original Message -
From: Jeff McKeon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 4:01 PM
Subject: Data from two tables
-
From: Jeff McKeon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 4:01 PM
Subject: Data from two tables in one query
We're currently running mysql ver 3.23 with plans to upgrade to 4.x soon
but we're not ready yet.
I have two tables that are identical, table1
I'm
merging or can I just grab the ones I want?
Jeff
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 10:54 AM
To: Rory McKinley; Jeff McKeon; [EMAIL PROTECTED]
Subject: Re: Data from two tables in one query
Two points about
At 11:14 -0400 10/14/03, Jeff McKeon wrote:
Paul,
- Original poster suggests that MERGE tables are not implemented until
4.0, but this is incorrect. MERGE tables are available as
of MySQL 3.23.25.
Very true, I must have misread. Now my question is, when I create a
merge table, do I have
union isnt available with 3.23 either
Nitin
- Original Message -
From: Rory McKinley [EMAIL PROTECTED]
To: Jeff McKeon [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 8:01 PM
Subject: Re: Data from two tables in one query
Hi Jeff
Have you looked at UNIONS
AM
To: Jeff McKeon; [EMAIL PROTECTED]
Subject: RE: Data from two tables in one query
At 11:14 -0400 10/14/03, Jeff McKeon wrote:
Paul,
- Original poster suggests that MERGE tables are not
implemented until
4.0, but this is incorrect. MERGE tables are available as of
MySQL
At 11:50 -0400 10/14/03, Jeff McKeon wrote:
Ok, created the merge table, now I get this error when I log into the
mysql server
[snip]
Didn't find any fields in table 'SuperMailbox'
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3903 to server version:
, October 14, 2003 11:59 AM
To: Jeff McKeon; [EMAIL PROTECTED]
Subject: RE: Data from two tables in one query
At 11:50 -0400 10/14/03, Jeff McKeon wrote:
Ok, created the merge table, now I get this error when I log
into the
mysql server
[snip]
Didn't find any fields in table
: Data from two tables in one query
At 11:50 -0400 10/14/03, Jeff McKeon wrote:
Ok, created the merge table, now I get this error when I log
into the
mysql server
[snip]
Didn't find any fields in table 'SuperMailbox'
Welcome to the MySQL monitor. Commands end with ; or \g.
Your
10 matches
Mail list logo