Jump to content


Photo

Relational Tables Concept.


  • Please log in to reply
3 replies to this topic

#1 Fahid

Fahid
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts
  • LocationPakistan

Posted 08 October 2005 - 10:17 PM

Hello all !
First of all, I am a newbie to MySQL, infact to databases, so if I say something wrong, please point it, and accept my apology.
Let's move on.........

I Just want to know if MySQL support Relational DataBase Managment Systems(RDBMS).
I just remember a thing about MS Access (I learnt in my high school days).
You can relate feilds from one table to another. And it's really a useful feature.
If you have changed a field from one table, other table will change it automatically.

I am looking for this feature in MySQL, but looking at option provided in PHPmyadmin v2.6.0, I seems like this useful feature is not available in MySQL.
Is it available ?
If yes, then how can we define a relation between same fields from morethan one table ?
Back Again...

#2 akitchin

akitchin
  • Staff Alumni
  • Advanced Member
  • 2,516 posts
  • LocationCalgary, AB, Canada

Posted 08 October 2005 - 10:54 PM

you can assign foreign keys using the InnoDB engine. i haven't read enough to know whether changing the value in the parent table changes the value in the child table, but i DO know you can specify delete activity (Cascade deletion, Nullify, etc.).

have a look in the MySQL manual for InnoDB documentation. i think there's a whole chapter on the engine.

#3 daiwa

daiwa
  • Members
  • PipPip
  • Member
  • 21 posts

Posted 08 October 2005 - 11:14 PM

Well i think first your answer is yes mysql is a relational database if you want it to be. but does not enforce foreign key constraits or support the term foreign key but you can do anything you'd want with it including being relational

#4 Fahid

Fahid
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts
  • LocationPakistan

Posted 08 October 2005 - 11:29 PM

Thanks akitchin and daiwa.
Now I can read the NySQL manual for InnoDB engine to find out more, thanks for guidance.
Back Again...




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users