Basic Question about DELETE

From: Ike (rxv_at_hotmail.com)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 12:30:17 GMT

Just a basic question regarding a relational database like MySQL.

I am using a MySQL database wherein tables are, naturally, linked to other
tables via indexes. Say I have tableA and tableB. TableB has a field which
contains a link to tableA.

Each day, operations are performed wherein a third table, tableC, is
created, with a history of the days actions, and thus contains links to the
other tables.

Now, if I delete a record in tableA dont I destroy the integrity of the
database? Or, to a lesser extent, if I destroy a link in tableB also. How
does one maintian the integrity of the database while allowing records to be
deleted? How do you typically do that?

Thanks, Ike

Relevant Pages