AW: Copy some datasets including the foreign key constraints

2006-11-23 Thread Eidner, Fabian
an easy way to copy the "parent" table an all his childs but with the new key values. Currently i do this via an PHP script, but it is a lot of work and not very flexible. Dosen't provide mysql any easy function ? Kind regards -Ursprüngliche Nachricht- Von: Jerry Schwa

Copy some datasets including the foreign key constraints

2006-11-22 Thread Eidner, Fabian
Hello list, I'm pretty new here. But i already got an problem. I'm working a while with mysql currently i'm trying to duplicate some entries in my tables. The problem is, i'm using foreign key constraints between those tables and i also would like to duplicate the childs. So i got one big parent,