--- 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
> usin
> 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
Ado
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 automa
--- 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
>
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 speci
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 0
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
> ge
