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?
Bashir ahmad 0 Light Poster
babbu -12 Posting Whiz in Training
delete * from tablename where primarykeyname = valuetobedeleted Bashir ahmad 0 Light Poster
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.