At 17:25 -0600 on 07/09/2004, Jonathan Duncan wrote about Re: Weeding
out duplicates:
For the information of someone who may need it in the future. I used
Jeffrey's idea for determining duplicates. Then I created a temporary
table, and used insert...select to put the id's of the duplicates in t
At 10:25 -0600 on 07/09/2004, Jonathan Duncan wrote about Re: Weeding
out duplicates:
Lachlan,
I want to identify the entries in the table where the email addresses
are the same as another entry. Whatever else is in the record does not
matter to me.
However, a second requirement for the query is
I highly recommend simply using ext3 for your Linux
setup. The 1 or 2 percent performance benefit that
you may get from raw partitions is way outweighed by
complexness of backups of the raw data.
either way:
First I would suggest you read the Linux RAID howto:
http://www.tldp.org/HOWTO/Software-
i'm trying to get a better understanding of how to implement persistent
connections with mysql in either perl/php
basically i'm trying to solve the issue of whether a web app has to
essentially perform a new mysql_connect on every page that's going to be
doing any database access.
using mysql_con
I'm trying to SELECT a field (ProductID) from 'Table a' WHERE two
corresponding fields are equal (a.PUBLISHER = b.Vendor AND a.NUMBER = b.VIN)
Table 'a' (approximately 100,000 records):
++
| ImportLiebermansStep3Add |
++
| Prod
select Vendor, ID, count(*) from ImportTable group by Vendor, ID having
count(*) > 1;
-Original Message-
From: Jeff Gannaway [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 10, 2004 5:11 PM
To: [EMAIL PROTECTED]
Subject: Is there an easy way to find duplicate records in a table?
I have a
Karam,
A much more secure way is to use OpenSSH (www.openssh.org) to create an
encrypted connection between the local machine and the MySQL server and to
use the -L option to forward MySQL commands from the localhost to the MySQL
server.
For example,
ssh -l -L 3306::3306
Once the ssh connect
I've got one huge table (table a), and two smaller tables (tables b and c)
I need to find which records in 'table a' are not in 'table b' nor are they
in 'table c'.
The Primary Key for all 3 tables is 'ProductID'.
I looked at the LEFT JOIN command in the docs, but it looks like you can
only comp
Michael Mason wrote:
I'm new to MySQL and already very impressed with it's flexibility,
speed and functionality. This in mind, I am looking for a way to allow
users to upload documents to the server for later retrieval by an
administrator.
Can this be done or will I have to find a nasty thir
I have a table that our distributor sent us. The table doesn't have any
keys. It does, however, have 7,782 duplicate records. I found this out
when I tried to have MySQL make a unique product ID by combining 2 fields
of each record.
Here's what I need to know...
Is there a MySQL command that
Hello again.
I'm new to MySQL and already very impressed with it's flexibility,
speed and functionality. This in mind, I am looking for a way to allow users to
upload documents to the server for later retrieval by an administrator.
Can this be done or will I have to find a nasty thi
I am trying to run the MySQL that comes with Red Hat Linux 7.3.
It is MySQL 3.23.49 for Red Hat Linux on i386. I can not get it to start and then stay
on.
>From root I type : /etc/init.d/mysqld start
I get : Starting MySQL [OK]
then it immediately goes back to root: [EMAIL PROTECTED] root
Craig-
are you sure you want to test
ranking_id < '10' ???
-martin
- Original Message -
From: "Craig Hoffman" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, July 09, 2004 3:51 PM
Subject: Re: Between Operator
> Thanks everyone for helping out.I took Michael's advic
Using INNER JOINs with the STRAIGHT_JOIN option so that the main table
displayed first in the EXPLAIN eliminated the temporary table being created
and the query speed went from 2.3 seconds to 0.2 seconds. Note that this
only works for queries where the offset in the LIMIT is small. As the offset
Jeff,
You need to use a Left Join which will join rows from the second
table even if the rows from the second table does not exist, and returns
NULL for all column for the second table.. You then use the Where clause to
check for a particular Table2.field that should exist (like Id colum
Jeff Gannaway wrote:
I have 2 tables - ProductsOLD and ProductsNEW. I need to find the
records that are in the ProductsOLD table and are NOT in ProductsNEW
(this will tell me which products have been discontinued).
Here's some sample data:
+==+
| ProductsOLD |
+==+
+ Ve
I have 2 tables - ProductsOLD and ProductsNEW. I need to find the records
that are in the ProductsOLD table and are NOT in ProductsNEW (this will
tell me which products have been discontinued).
Here's some sample data:
+==+
| ProductsOLD |
+==+
+ Vendor | ID |
+---
Hi Again
i forgot to mention that this table has 527101 rows, and takes 90mb when it
is dumped to the disk. I dont have this freeze problem when i dump the
smaller smaller tables that also uses InnoDB.
i Also discovered that it is not on the same posistion ind the dump file the
lockup happens.
N
Hi
I still got this freeze problem, i have found out that this bug is related
to InnoDB, i converted the table that gives problems back to MyISAM, and the
dump operation runs fine just as it did before, but as soon as i convert it
to InnoDB and dump this table my system freezes but not the first t
Hello,
Recently lot of MySQL clients try to overcome host
based privilege system of MySQL by using PHP tunneling
method.
In this method they call up a PHP file in the server
and the PHP file executes a query and sends the data
in XML format.
I am using C API() and I was just wondering if
somebo
I bought a supermicro 6013p-t for the 4 sata raid hard drives support.
Unfortunately, it doesn't really have raid at all. So I'm forced to use
software raid. What I'd like to use is fedora core 2 with an innodb
filesystem on a software raid partition according to these instructions:
http://dev.m
21 matches
Mail list logo
