--- 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
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
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
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
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
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
10 matches
Mail list logo