0

This is my table schema, which have composite key (username,emailid,phone)

How to validate similar record not exist in the table.

Example

username         emailid       phone      
abc            test@one.com   123456789    
abc            test@one.com   123456789
abc            test2@one.com  123456789
abc            test@one.com   456789269
abc            test2@one.com  456789269
abc            test@one.com   123456789    

How restrict last record inserted inthe above table.

validation should perform under three fields record.

Bharanikumar
  • 25,457
  • 50
  • 131
  • 201

0 Answers0