bruce wrote:
thanks for the reply...
and my bad on the diff between the sql. the actual sql had ~100 values. (i
simply cut it to demonstrate what i'm trying to do!!)
i took the two tables created by the initial sql statements and modified
them so that they both had the same structure. i then added/
u1.universityID='257'
> or u1.universityID='267' or u1.universityID='379' or
u1.universityID='394'
> or u1.universityID='460' or u1.universityID='541' or
> u1.universityID='560'
>
>
> -Original Mess
;.
thanks
-bruce
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 29, 2004 7:27 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: merging of two tables using temp tables???
Bruce,
My first thought was the LEFT JOIN Jacques suggested.
lly do a select on the
resulting table to get the values i need...
looking through google/mysql hasn't shed any light on this one...
any ideas/thoughts/comments on how i can do this.
-Original Message-
From: Jacques Jocelyn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 28, 200
D='379' or u1.universityID='394'
or u1.universityID='460' or u1.universityID='541' or
u1.universityID='560'
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 29, 2004 6:42 AM
To: [EMAIL PROTECTED]
If you post your two "original" SQL statements (the ones you use to build
your example tables) I think I can help you to merge your results,
possibly without the need for temporary tables. Also, what version of
MySQL are you using?
Shawn Green
Database Administrator
Unimin Corporation - Spruce
acques Jocelyn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 28, 2004 10:20 PM
To: bruce; [EMAIL PROTECTED]
Subject: Re: merging of two tables using temp tables???
Hello bruce,
Wednesday, September 29, 2004, 6:57:34 AM, you wrote:
b> hi
b&
Hello bruce,
Wednesday, September 29, 2004, 6:57:34 AM, you wrote:
b> hi
b> i'd like to be able to merge/combine the two tables so that i get
b> +--+--++--+---+-+
b> | ID | type | status | user | ID| uID |
b> +--+--++--+---+-
hi
i have a situation where i create the following tables via two different
select sql statements.
+-+--+---+--+-+
| ID | type | user | ID | uID |
+-+--+---+--+-+
| 40 |1 | admin | 157 | 40 |
| 102 |1 | admin | 405 | 102 |
| 257 |1 |
CREATE TEMPORARY TABLE
SELECT *
FROM
...
Query temp table
...
DROP TABLE
-Original Message-
From: bruce
To: [EMAIL PROTECTED]
Sent: 8/10/04 12:45 AM
Subject: using temp tables...
hi...
in trying to get a better understanding of temp tables. is there a way
to
perform a select, to
Temporary tables work pretty much like regular tables, except they don't last.
CREATE TEMPORARY TABLE bar SELECT * FROM foo WHERE ...
UPDATE bar SET ...
SELECT * FROM foo JOIN bar on foo.id = bar.id WHERE ...
Michael
bruce wrote:
hi...
in trying to get a better understanding of temp tables. i
hi...
in trying to get a better understanding of temp tables. is there a way to
perform a select, to write the results to a temp table, and then use the
temp table to perform another operation on the information within the temp
table...
ie...
select * from
foo
write the results of the select to
cation i start this sql:
SET SQL_SLAVE_SKIP_COUNTER=1;slave start;
>How-To-Repeat: using temp tables in stateme
>Fix: no idea
>Submitter-Id: Stefan Meyer
>Originator:[EMAIL PROTECTED]
>Organization:
MobilCom Communications GmbH
>MySQL support: none
>Synopsis:
13 matches
Mail list logo
