You didn't even say that (svr, started, ended, volume, who, action) was a
unique combination of values for either table. If that is the case then
you will have a hard time matching rows of one table uniquely to rows of
the other table.
Shawn,
Sorry for the lack of clarity on my part. The combina
you didn't say that (svr,started,ended,volume,who) is a unique key...
If not, it would explain the result and the extra rows you get.
Well... that combination of fields *should* be unique. Does a unique index
need to be specified on those columns? It is possible that
(svr,started,ended,volume,
I'm struggling with this, and am not sure what I'm doing wrong... There
are two tables in separate databases that have 6 fields in common. In
addition to the six columns in common between table_a and table_b, each
table has some additional fields that are not related. Table_a and table_b
each
Greetings,
The project I'm working on involves extracting data from one database and
storing it in another.
With the goal of creating a generic mechanism (perl script) to perform the
extraction on a periodic basis, I set up a table mapping destination table
and column to the source of the valu
Regarding number 1, you might be able to do something with this:
mysql> show variables like 'pid%';
+---+-+
| Variable_name | Value |
+---+--
Is the table indexed in any way?
At 03:40 PM 10/6/2004, you wrote:
Hello,
I recently began experiencing issues that I would like some assistance with.
Server Details:
- Windows 2003
- MySQL Max 4.0.20a
I have a table with 450,000+ records in it. When I try to run a single
query, such as selecti
I'm by no means an expert on this, but some things you might want to
consider...
An alternative method to not impact the disk space on the 32-bit system:
If you have connectivity between the 32-bit and 64-bit systems is to use
mysqldump on the 64-bit system and specify the 32-bit host using the
At 04:05 PM 10/4/2004, [EMAIL PROTECTED] wrote:
I guess the docs aren't totally clear on this as you are not the first
person to have problems forming a multiple-table UPDATE statement.
Thanks for the quick response. It's somewhat gratifying to hear that I'm
not alone in my confusion...
Ted
--
Greetings,
I'm trying to update existing records in one table so that value of a
column winds up matching the value of a column in a second table, based on
a match in a second column in each table.
I'm not sure if I'm taking the wrong approach on this, of if I'm missing
something simple in the
for pointing out the mysqlimport tool - that sounds like what I
should really be using instead of cut-n-paste...
Ted
At 08:08 PM 9/29/2004, Andrew Kreps wrote:
On Wed, 29 Sep 2004 10:05:29 -0400, Ted Byrne <[EMAIL PROTECTED]> wrote:
>
> Is the apparent line length limit a restriction im
Greetings,
I posted this to the MySQL Newbie forum, but have not received a
response. Any feedback would be appreciated.
-tb
Environment:
mysql server v4.0.13 (Win2K)
mysql client v5.0.0.0(Win2K)
In attempting to (manually) insert records with some rather lengthy
strings, I pasted the insert st
11 matches
Mail list logo