Hi group,

Is there anyone out there that knows a good innoDB/foreign keys
tutorial.
I read upon it on the mysql site, but i find that information rather
brief.
I've searched Google, but it seems a bit hard to find some decent tuts.

Thanks in advance.

Frizzle.

frizzle wrote:
> Hi group,
>
> Is there anyone out there that knows a good innoDB/foreign keys
> tutorial.
> I read upon it on the mysql site, but i find that information rather
> brief.
> I've searched Google, but it seems a bit hard to find some decent tuts.

What did you search on? I just tried the keywords "foreign key tutorial
mysql" in a Google search, and it found many tutorials on using
referential integrity in MySQL.

Try this one:
http://www.databasejournal.com/featu...le.php/2248101

Regards,
Bill K.

Bill Karwin wrote:
> frizzle wrote:
> > Hi group,
> >
> > Is there anyone out there that knows a good innoDB/foreign keys
> > tutorial.
> > I read upon it on the mysql site, but i find that information rather
> > brief.
> > I've searched Google, but it seems a bit hard to find some decent tuts.
>
> What did you search on? I just tried the keywords "foreign key tutorial
> mysql" in a Google search, and it found many tutorials on using
> referential integrity in MySQL.
>
> Try this one:
> http://www.databasejournal.com/featu...le.php/2248101
>
> Regards,
> Bill K.

Thanks for the link.
I really did search for it, but the best that i coulc come up with was
the mysql.com article on it. As i said, kind of brief info.

Frizzle.

On 18 Jul 2006 10:45:44 -0700, frizzle wrote:
> I really did search for it, but the best that i coulc come up with was
> the mysql.com article on it. As i said, kind of brief info.

A lot of the documentation on the MySQL site is (appropriately) about
MySQL and how MySQL implements SQL. Foreign key constraints are pretty
standard things in moderately sophisticated SQL engines and most books
on SQL in general cover them. A doubled approach to learning this should
be 1) a general book on SQL and 2) documentation for your particular
DBMS. You'll probably want to look at the book introduction or preface
to see how product-specific it is.


--
"The last refuge of the insomniac is a sense of superiority to the
sleeping world."
--Leonard Cohen, The Favourite Game