Is it possible to use a primary key to avoid duplicates? The reaction to
duplicate rows will depend on what type of statement you are issuing.
An update/delete would update/delete all rows that are relevant, a select
would return multiple rows with the same values.
-Original Message-
On Sun, Mar 21, 2004 at 07:24:48PM -0800, Axel IS Main wrote:
I have a php app that updates an ever growing table with new
information on a regular basis. Very often the information is
duplicated. I'm currently handling this by checking the table for
duplicate values every time I go to add new
Axel IS Main wrote:
I have a php app that updates an ever growing table with new information
on a regular basis. Very often the information is duplicated. I'm
currently handling this by checking the table for duplicate values every
time I go to add new data. As you can imagine, as the table
-- Original Message --
From: Pete Kuczynski [EMAIL PROTECTED]
Date: Tue, 26 Jun 2001 13:19:02 -0500
I want to prevent duplicate entries into my mysql database which holds
invertory of all network eqpt at my site. Engineers access it thru
netscape and the
My primary key field is a auto incremented index, the field I want to
make unique, or to say, prevent duplicates in, is the hostname field,
which has, hostnames of devices. Is the key word UNIQUE then?
Not all of the devices have hostnames assigned to them, like terminals,
so the hostname field
-- Original Message --
From: Pete Kuczynski [EMAIL PROTECTED]
Date: Tue, 26 Jun 2001 14:02:08 -0500
My primary key field is a auto incremented index, the field I want to
make unique, or to say, prevent duplicates in, is the hostname field,
which has,