I have MySQL available to me from my webserver. If I'd like to post daily updates of baseball players' batting averages, home runs, ie. things that change daily.

How would I go about this?

Or, is there another database/easier way to accomplish this?

Please explain this to me in as much detail as possible.

Thank you

There are plenty of databases, and if you already know SQL Server, it would be much easier because you wouldn't have to learn a new syntax, and learn what part of the syntax has changed. It sounds like that isn't the case, tho - so in your situation, one RDBMS engine will be as easy as the next.

A database is a data persistence mechanism. It lets you store and retrieve information, and it's very good at looking at existing data in new ways. You could do much the same thing with flat files or XML. Or a scraper thing or a data feed from the major league, or teams, or whoever might provide that info?

What you want is an application. You'll benefit from designing your app first, and letting that drive the data persistence design.

Something that might be useful to know is whether or not you'll be entering in the stats manually or getting them from another site.

Originally Posted by VirtuosiMedia

Something that might be useful to know is whether or not you'll be entering in the stats manually or getting them from another site.

I'd like to educate myself on both scenarios and then reach a decision from there.

You'll have to spend some money, I think, to get the stats. I'm not sure how much. There is a service called StrikeIron that has an API for baseball stats, which you can find here. There may be other ones, but that's the only one I know about. If you're serious about your idea, you'll probably want to automate the process and get the stats from a service. It might cost a little, but I would imagine that it would beat entering hundreds of stat lines every morning. With a service, you have a better chance of getting live stats.

OK, let's look at it from the point of view where I'd access it from a database. What are the steps and procedures?

Thanks!!