Doing select @a does not work in replication.

ou for your time, 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]

RE: Mysql hangs on multi table update on innodb table.

FOREIGN KEY (parent_id) REFERENCES parent(id) > ON DELETE 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

Mysql hangs on multi table update on innodb table.

, 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) To

RE: Bug with innodb multi-table delete and foreign keys.

ere parent.id=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

Bug with innodb multi-table delete and foreign keys.

et id=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

A bug with innodb and non innodb multi-table delete.

=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

InnoDB foreign keys bug

; 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

Innodb Foreign Key Problems.

. Fix? 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 PROTEC

Mysql replication servers in circular setup

g what are some 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)