2 MySQL Data Questions

[Hiedenat]

I've fallen down a rabbit hole again. I am a novice with MySQL, but my questions have more to do with specific OOTP data than with SQL itself (I have books and the internet for that). Cross-posting to the General forum too, as I am not sure how much traffic this sub-forum gets, so trying my luck there as well.

1. On the players_career_batting _stats table, there is a field called split_id, and it effectively breaks a player's season into different records. In most cases, the player is on the same team in the same year for these splits. My question is, how do I interpret these splits? What do they mean?

2. Where can I find players' historical salaries? The players_contract table seems to only show the values for their current contracts.

Thanks!

[Hiedenat]

Originally Posted by Hiedenat

I've fallen down a rabbit hole again. I am a novice with MySQL, but my questions have more to do with specific OOTP data than with SQL itself (I have books and the internet for that). Cross-posting to the General forum too, as I am not sure how much traffic this sub-forum gets, so trying my luck there as well.

1. On the players_career_batting _stats table, there is a field called split_id, and it effectively breaks a player's season into different records. In most cases, the player is on the same team in the same year for these splits. My question is, how do I interpret these splits? What do they mean?

2. Where can I find players' historical salaries? The players_contract table seems to only show the values for their current contracts.

Thanks!

Any updates??
https://itrate.co/software-developme...san-francisco/

[Snarpy]

We have no idea where your data comes, what any field means, or what the schema of your database is beyond the table name and field name you have shared. You need to go to the source of your data (who is collecting or publishing it) for metadata on what things mean.