Re: Beginner question - Preventing Duplicate Entries

2003-03-27 Thread Brian McCain
oc/en/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 Su

RE: Beginner question - Preventing Duplicate Entries

2003-03-26 Thread Wynne Crisman
. 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 En

RE: Beginner question - Preventing Duplicate Entries

2003-03-26 Thread Wynne Crisman
wise you will likely have 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 entr

Beginner question - Preventing Duplicate Entries

2003-03-26 Thread Wileynet
Is there a sql statement that would not allow the same entry twice. Something like INSERT into myTable s WHERE s != Value(?). I don’t 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 exam