Re: Combo of 2 fields needs to be unique

2006-09-04 Thread Vincent . Badier
Hello Brian, IMHO if you put this combinaison as a uniq key, any insert with this combinaison already existing will fail Vincent Brian Dunning <[EMAIL PROTECTED]> 04/09/2006 16:49 To: mysql@lists.mysql.com cc: Subject: Combo of 2 fields needs

Combo of 2 fields needs to be unique

2006-09-04 Thread Brian Dunning
I'm tracking site visitors with a database - one field is the IP address, the other is the page they've visited. I don't want any duplicates of this combination. Is there a MySQL statement similar to INSERT IGNORE but will ignore only if the combination is duplicated? -- MySQL General Maili