title: How to use cascade? mine is not working
body: <p>here is my table....</p>
  
  <pre><code> create table c1(id int primary key,name varchar(20));
   create table c2(iid int primary key,ename varchar(20),foreign key(iid) references       c1(id) on update cascade on delete cascade);
  
   insert into c1 values(1,'a');
   insert into c1 values(2,'b');
  
   insert into c2 values(1,'a')
   insert into c2 values(2,'b')
  
   update c1 set id=3 where id=1;
   update c1 set name='hello' where id=2;
  </code></pre>
  
  <p>when i updating something nothing happens.. </p>
  
  <p>What is actually cascade, does it actually update values for c2's tables ID when I update on c1..</p>
  
  <p>what i actually think is that above update query should change the value of c2's id value where id=1...</p>
  
  <p>if i am wrong.. pls tell me how to update values in c2 when i update on c1...
  Thank you...</p>