--- 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 t
--- 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 t
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
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 from the details table without specifying this in
How can I set up mysql so as if the id of an entry from table 1 is
inserted in table 2 it will not allow me to delete the information in
table 1?
EX:
table1 holds the description of the products (table1_id is the primary
key of the table);
table2 holds the information about all the purchased p
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
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 pieces of information in an index table that wil
10 matches
Mail list logo
