-
From: Axel IS Main [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 21, 2004 10:25 PM
To: [EMAIL PROTECTED]
Subject: Preventing Duplicate Entries
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
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 grows it
takes longer
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
/CREATE_TABLE.html and
http://www.mysql.com/doc/en/ALTER_TABLE.html for information about keys.
-Brian McCain
- Original Message -
From: Wileynet [EMAIL PROTECTED]
To: 'mysql users' [EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 3:03 PM
Subject: Beginner question - Preventing Duplicate Entries
Is there a sql statement that would not allow the same entry twice.
Something like INSERT into myTable s WHERE s != Value(?). I dont know
if that makes sense but I thought I would give it a shot.
Basically I want to know if it is possible and if so can you point me to
a webpage or give me an
deadlocks.
~Wynne
-Original Message-
From: Wileynet [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 2:04 PM
To: 'mysql users'
Subject: Beginner question - Preventing Duplicate Entries
Is there a sql statement that would not allow the same entry twice.
Something like INSERT
. This of course would require transactions supported
by InnoDB tables and not supported by MyISAM.
~Wynne
-Original Message-
From: Wileynet [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 2:04 PM
To: 'mysql users'
Subject: Beginner question - Preventing Duplicate Entries
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 query insert is done via pdp [below].
I will place the script into php, any pointers on this would be
appreciated.
THX!
Pete
html
-- 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,
12 matches
Mail list logo