-
Remove a duplicate record
I somehow duplicated 2 records in my database. Is there a way to delete the duplicates?
-
You have to write a query to identify duplicates and delete them. The syntax depends on the database system you are using. Typically you compare columns that should uniquely identify a record and pick one of the duplicate as delete candidate based on some additional criteria such as timestamp.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|