> I have a database which has identical entries. Is there
> a way to tell mySQL to throw out duplicate entires
> when un insert/update is done via ColdFusion?
Tell mySQL that the columns are UNIQUE.
Alec
---
Create an unique index.
See: http://www.mysql.com/doc/en/CREATE_INDEX.html
Regards,
Joseph Bueno
FlashGuy wrote:
> Hi,
>
> I have a database which has identical entries. Is there a way to tell
> mySQL to throw out duplicate entires when un insert/update is done via
Hi,
I have a database which has identical entries. Is there a way to tell mySQL to throw
out duplicate entires when un insert/update is done via ColdFusion?
---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
On 6/11/01 11:11 PM, "Jari Mäkelä" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> how a field ( names of products ) of database should be defined so that you
> could not enter identical entries at the field?
>
> Or does one need to do the validation before inserting i
Hi,
Jari Mäkelä wrote:
>
> Hi,
>
> how a field ( names of products ) of database should be defined so that you
> could not enter identical entries at the field?
If you create an 'UNIQUE INDEX' on that field, mysql will not allow you to
enter duplicate values (yo
Hi,
how a field ( names of products ) of database should be defined so that you
could not enter identical entries at the field?
Or does one need to do the validation before inserting info?
Jari Mäkelä
-
Before posting
