On Wednesday 04 December 2002 12:48, Greg Petty wrote:
How does MySQL compare to SQL? Are they
> interchangeable? I have already implemented a Linux file/print and
> working on adding an Apache webserver onto my network, and I’d like to
> add a MySQL db server if at all possible.
MySQL is simply a version of the SQL language as far as I understand it.
You've got a million and one versions (well maybe not ThAT many, but it's a
decent #) of SQL based languages (M$SQL, PostGresql, MySQL are the top three
the come to my mind).
Adding a MySQL server is actually easily done, if you've got a redhat system,
find the rpm's and install them. otherwise, head on over to www.mysql.com,
dig around there a bit (you might be better off doing a search on freshmeat
for a direct link).
As far as MySQL vs files, well, that's just my personal preference.
Eventually, I'll have the majority of the structures saved/loaded in sql, in
order to deal with web based playing as WELL as client based (that one's
still a LONG way down the road though). Editing users in this type of a
database completely frees up everything though. No need for pload,just pset
player (blah, value), and if it is a legal area to be set it's done, whether
they're on or off line. It's definitely got its advantages to flat files.
