i use cascade on delete but my output don't reflects changes please help .. and tell whether m using correct syntax.
mysql> create table abc ( id int , name char , primary key(id));
Query OK, 0 rows affected (0.19 sec)

mysql> insert into abc values ( 10 , 'a');
Query OK, 1 row affected (0.04 sec)

mysql> insert into abc values ( 20 , 'b');
Query OK, 1 row affected (0.03 sec)

mysql> insert into abc values ( 30 , 'c');
Query OK, 1 row affected (0.04 sec)

mysql> select * from abc;
+----+------+
| id | name |
+----+------+
| 10 | a |
| 20 | b |
| 30 | c |
+----+------+
3 rows in set (0.04 sec)


mysql> create table pqr ( pid int , pname char , pdi int references abc(id) on d
elete cascade);
Query OK, 0 rows affected (0.08 sec)

mysql> insert into pqr values ( 90 , 'm' , 30);
Query OK, 1 row affected (0.04 sec)

mysql> insert into pqr values ( 100 , 'n' , 30);
Query OK, 1 row affected (0.02 sec)

mysql> insert into pqr values ( 100 , 'n' , 20);
Query OK, 1 row affected (0.03 sec)

mysql> select * from pqr;
+------+-------+------+
| pid | pname | pdi |
+------+-------+------+
| 90 | m | 30 |
| 100 | n | 30 |
| 100 | n | 20 |
+------+-------+------+
3 rows in set (0.00 sec)

mysql> delete from abc where id=30;
Query OK, 1 row affected (0.09 sec)

mysql> select * from abc;
+----+------+
| id | name |
+----+------+
| 10 | a |
| 20 | b |
+----+------+
2 rows in set (0.00 sec)

mysql> select * from pqr;
+------+-------+------+
| pid | pname | pdi |
+------+-------+------+
| 90 | m | 30 |
| 100 | n | 30 |
| 100 | n | 20 |
+------+-------+------+
3 rows in set (0.00 sec)