[wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP

2003-03-19 Thread Paul Larue
- Updating a parent table won't update the child table - HELP Paul wrote: I thought about that one but the result will be that if I want to have, let's say, a list of employees and their associated groups, I would have to make a UNION select on the 2 tables to get the associated employee_group

[wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP

2003-03-19 Thread Furry, Tim
Paul wrote: I thought about that one but the result will be that if I want to have, let's say, a list of employees and their associated groups, I would have to make a UNION select on the 2 tables to get the associated employee_groups.grp_name since employees.emp_group only contains the ID of the gr

[wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP

2003-03-18 Thread Paul Larue
to:[EMAIL PROTECTED] Sent: 19 March 2003 04:13 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP Sonja, I thought about that one but the result will be that if I want to have, let's say, a list of employees and th

[wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP

2003-03-18 Thread Van Der Westhuizen, Sonja
19 March 2003 04:13 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP Sonja, I thought about that one but the result will be that if I want to have, let's say, a list of employees and their associated groups, I would h

[wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP

2003-03-18 Thread Paul Larue
[wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP Hi Paul, I hope I understand correctly (little sleep can make you see things)... In MSSQL when a record gets updated it "deletes" it first and then it "inserts" the new infor

[wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP

2003-03-18 Thread Van Der Westhuizen, Sonja
at will be. I hope this helps. Sonja -Original Message- From: Paul Larue [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 02:29 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP Me again, Anybody can help? Pa

[wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP

2003-03-18 Thread Paul Larue
Me again, Anybody can help? Paul -Original Message- From: Paul Larue [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 9:58 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] [MySQL] InnoDB - Updating a parent table won't update the child table Hi all, I created 2 tables in MySQl with