--- Adolfo Bello [EMAIL PROTECTED] wrote:
As far as I know and how I understand it, the relationships are basically
all
in your head... You just have to coordinate it in your queries and other
functions
This is not true. Fot type innodb tables, you can define REFERENCES
using ON DELETE
As far as I know and how I understand it, the relationships are basically all
in your head... You just have to coordinate it in your queries and other functions
This is not true. Fot type innodb tables, you can define REFERENCES
using ON DELETE (CASCADE|RESTRICT) and/or ON UPDATE CASCADE
Octavian Rasnita wrote:
Is MySQL able (like MS Access) to define permanent relations between tables?
For example, I want to define a master - child relation between 2 tables so
when deleting some entries from the master table to automaticly delete the
entries from the details table without
--- Octavian Rasnita [EMAIL PROTECTED] wrote:
Hi all,
Is MySQL able (like MS Access) to define permanent relations between tables?
For example, I want to define a master - child relation between 2 tables so
when deleting some entries from the master table to automaticly delete the
entries
On Fri, Jan 10, 2003 at 04:54:14PM +0200, Octavian Rasnita wrote:
Hi all,
Is MySQL able (like MS Access) to define permanent relations between tables?
For example, I want to define a master - child relation between 2 tables so
when deleting some entries from the master table to automaticly
On Wed, 04 Jul 2001, Mohan Khurana wrote:
database enthusiasts,
I'm fairly new to database administration and development, I'm currently
still learning about features of databases so that I can ensure that my
design for the database that I create will be correct. I will be storing
general
Mohan;
I'm also new to this database administration and development. There are
some excellent tutorials at Devshed.com.
Below is a link to the tutorial on Database Normalization, I think this
will give you some answers to your query:
http://www.devshed.com/Server_Side/MySQL/Normal/
Joe
At