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 i'd like to be able to merge/combine the two tables so that i get
b
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
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 29, 2004 6:42 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: merging of two tables using temp tables???
If you post your two original SQL statements (the ones you use to build
your example tables) I think I can
[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 i'd like to be able to merge/combine the two tables so that i get
]
Subject: Re: merging of two tables using temp tables???
Bruce,
My first thought was the LEFT JOIN Jacques suggested. My second thought was
that it would be better to just create a single query that gets what you
want in the first place. So I looked a little closer, and now I'm confused
PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: merging of two tables using temp tables???
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
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
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
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 +--+--++--+---+-+
b
CREATE TEMPORARY TABLE table
SELECT *
FROM source_table
...
Query temp table
...
DROP TABLE temp_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
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
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.
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: Replication Problem
Severity: non-critical
Priority
13 matches
Mail list logo