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-
From
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 gro
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 data
-- 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, h
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 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 t
