Re: Select from two tables not returning the expected number of rows

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

Re: Select from two tables not returning the expected number of rows

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

Select from two tables not returning the expected number of rows

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

Storing SQL in a column? - looking for advice

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

Re: Long Running Queries

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

Re: 2 questions: hostname variable and exit if slave

Regarding number 1, you might be able to do something with this: mysql show variables like 'pid%'; +---+-+ | Variable_name | Value |

Unknown table ... in where clause

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

Re: Unknown table ... in where clause

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 --

Re: Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit system?

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

Re: Newbie question - Input limitations on mysql client?

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 imposed

Newbie question - Input limitations on mysql client?

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