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 to be unique
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 Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
