Hi
just out of interest, 
How can I create unique "data sets", or rather, set a set of data as
unique, to prevent another entry in the table that meets the same
criteria,

for instance:

id      name    surname         address
1       john    doe             1 street
2       mary    jane            2 lane
3       john    doe             3 ave
4       john    doe             1 street

As you can see row one and row 4 is identical in all 3 collumns, so how
would I prevent a write like this to the table?






sql,query



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to