,
Scott Wong
Meiko America, INC
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
CASCADE
ON UPDATE CASCADE
) TYPE=INNODB;
insert into parent set id=1;
insert into child set id=1, parent_id=1;
update parent,child set parent.id=parent.id+1, child.parent_id=parent.id+1;
Thank you for your time.
Scott Wong,
Meiko America, INC
, child.parent_id=parent.id+1;
Thank you for your time.
Scott Wong,
Meiko America, INC
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
=child.parent_id;
now i get
ERROR 2013: Lost connection to MySQL server during query
mysql
Number of processes running now: 0
030213 15:54:20 mysqld restarted
regards,
Scott Wong
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 1:31 PM
=INNODB
;
CREATE TABLE child(id INT PRIMARY KEY, parent_id INT,
INDEX par_ind (parent_id),
) ;
insert into parent set id=1;
insert into child set id=1, parent_id=1;
delete parent,child from parent,child where parent.id=child.parent_id;
fix
?
Thank you for your time
Scott
=1, parent_id=1;
insert into grandchild set id=1, child_id=1;
delete parent,child from parent,child where parent.id=child.parent_id;
ERROR 1105: Unknown error
fix
?
Thank you for your time
Scott Wong
Meiko America, INC
;
The intesting thing is this :
show create table child;
FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON UPDATE CASCADE,
FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON DELETE CASCADE ON UPDATE
CASCADE
fix
?
Thank you for your time
Scott Wong
Meiko America, INC
?
Scott Wong,
Meiko America, INC
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
downfalls
on this idea?
Thank you.
Scott Wong
System Administrator
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread