Re: Removing data

44 views
Skip to first unread message

Joe Meyer

unread,
Oct 4, 2021, 4:26:03 PM10/4/21
to sdq...@googlegroups.com
John,

please remove your (American) football data from the FIFA (soccer) database.
This makes the FIFA database difficult to use and is not friendly.

Best regards,

Joe Meyer



On Thu, Sep 2, 2021 at 7:53 PM John Currey <jac...@gmail.com> wrote:
I figured out the issue, thanks. 

On Thursday, September 2, 2021 at 11:49:24 AM UTC-4 John Currey wrote:
I'd like to load NCAAFB data. Before I do, I have 4 games left in the database that I accidentally added with a date as a string. 

When I try to delete those last 4 records, I get this:
Sep2.JPG
When I try the build, I get this:Sep2a.JPG

There are fields in the database I no longer want. I'd really like to get those last 4 records out so I can start importing NCAAFB data. I tried removing the date key as a string and an integer, and neither is successful.

Here are the remaining games in the database:

Sep2b.JPG
Thanks

--

---
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/e119dca3-98e9-4adc-a2cb-0fa846426946n%40googlegroups.com.

John Currey

unread,
Oct 4, 2021, 10:03:06 PM10/4/21
to SDQL API
My apologies, I did not intend to be unfriendly. Data is on its way out right now. 

John Currey

unread,
Oct 5, 2021, 8:30:21 AM10/5/21
to SDQL API
My FIFA data is gone. However, I've noticed that the database does not seem to like to be empty. I can't seem to get rid of this game. However, if add new data, only the new data will be in the database. If there's a step I'm missing, please let me know. 

Joe Meyer

unread,
Oct 5, 2021, 10:36:37 AM10/5/21
to sdq...@googlegroups.com
John,

you can find your remaining game in the FIFA database with the SDQL:

team,date,si...@jcurrey.date>0

Please remove this last remaining game.

Joe


John Currey

unread,
Oct 5, 2021, 7:45:23 PM10/5/21
to SDQL API
Cool, done! Thanks Joe!
Reply all
Reply to author
Forward
0 new messages