hi all
I'm creating a table like this
CREATE TABLE test (
id integer not null primary key auto_increment,
test char(20),
father integer key default ='-1' not null,
FOREIGN KEY (id) RERERENCES test(padre) ON DELETE CASCADE
) Type=InnoDB;
But I made some mistakes on it, because i want it to act differently
from now
I want obtain something like this
table row example:
id test father
1 'aa' -1
2 'bb' 1
3 'cc' -1
4 'dd' 2
5 'ee' 2
6 'ff' 3
so relatives chains are
1-2-4
\-5
3-6
and then I want to delete all child from a id that is their father.
example
deleting 3 has to delete 3 and 6
deleting 2 has to delete 2,4,5
deleting 1 has to delete 1,2,4,5
I hope this could be enough to explain my SQL problem...
TIA
ALx
--
alx <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
