[SATLUG] mysql help

[Donn D]

Donn wrote:

>>label-id (PKs in their respective tables) would be
>>FKs in the ALBUM 
>>table.  Sooooo....  does mysql 3.23 do that "out of
>>the box".
>>
Travis replied:

>>It was my impression that mysql doesn't enforce
>>referential integrity, that it must be done by the
>>application.  So, just make those FK cols in ALBUM
>>integers, assuming that your PKs are autoincrement integers.
>>
>>
>>    
>>
Donn complains:

I'm a little bit irritated about mysql version 4 and FC.  Fedora 2 came 
out in 2004 and it seems that mysql 4 came out 2 years, or more, before.
"Yum install mysql" gets you version 3.23, and I am hearing that you 
can't use yum to upgrade to version 4.  It's some kind of licensing 
thing that RH/Fedora
is complaining about.  When I decided to learn something about databases 
(with mysql) I didn't know that I couldn't learn Referencial Integrity 
or FK usage
if I chose to use mysql.  Anyway, after wasting money on 2 mysql books 
(inexpensive ones thankfully) (all mysql books cover version 4 btw), I 
decide to learn Db stuff with another program. 
Maybe postgresql, or firebird... ?  any suggestions?  I just want to 
play with setting up Dbs, tables & such, and play around with them on a 
standalone machine
at home.  I want to learn ref. integrity, FKs, blah blah - by setting & 
using my large LP collection on a Db.
Thanks