Cascade Delete And Update

popskie · #1 (**permalink**) 09-23-05, 01:58

HI,
Im a mysql newbie, my problem is sounds easy to all mysql experts. I used mysql 5.0.1 beta. It is posible to to have a cascade delete and update here.
ok i have to give 2 tables here.

Code:

table1
idno  desc
0001  juan
0002  Rey

Table2 
idno  Type
0001  AAA
0001  BBB
0002  AAA
0002 CCC

if i delete idno 0001 in table1 . The corresponding record in table2 also where delete.
In Ms SQL it is posible.

Another question is, what is the diferent between unique and primary index?

Popskie

Popkie