Duplicate data issue

9 views
Skip to first unread message

John Currey

unread,
Jan 16, 2022, 11:28:52 AMJan 16
to SDQL API
Hi,

I'm not sure what I did to cause this, but I noticed I have 5 Super Bowls with duplicate records in the database. Here are the first three:


I know I can delete the sets of games and then re-add each SB once. My question is, does the best programmer on staff have a trick to remove just one of the games with a duplicate key?

Thanks.

Joe Meyer

unread,
Jan 17, 2022, 9:31:16 AMJan 17
to sdq...@googlegroups.com
John and SDQL API Friends,

I see that this was caused by an extra space after the team name for those games.
For example, you had entered one game for the 'Ravens' and one game for the 'Ravens '.

I have removed the extra games and will get my best programmer on protecting against this in the future.

Best regards

Joe Meyer
Sports Database LLC

--

---
You received this message because you are subscribed to the Google Groups "SDQL API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdqlapi+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/885a6390-3227-4c7c-ae59-fb545c87a1b1n%40googlegroups.com.

John Currey

unread,
Jan 17, 2022, 10:45:36 AMJan 17
to SDQL API
Thanks Joe!
Reply all
Reply to author
Forward
0 new messages