Member Avatar for Bashir ahmad

I enter 3 identical records in an sql database table. Normally this should not have happened as the DBMS must check for identical records. Now when I try to delete or update these records, an error message is shown. What to do?

  • 2 Contributors
  • 2 Replies
  • 222 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Bashir ahmad
Member Avatar for babbu 
delete * from tablename where primarykeyname = valuetobedeleted
Member Avatar for Bashir ahmad

thx for the reply. had there been a primary key in the table, it would not have been possible to enter identical records. ur reply is quite ok if there is a primary key in the table. then instead of using sql stmnt, the record can be directly deleted.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.