Set a primary key / unique key on a column (s) in myTable to make that row unique.
Goto mysql.com and type primary key in the search dialog. There is a wealth of knowledge there. Or use google site:mysql.com Primary Key syntax -----Original Message----- From: Wileynet [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 3:35 PM To: 'mysql users' Subject: beginners question - Not Makine Duplicate Entrys 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 example if you can? Thanks in advance - Wiley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]