RE: Copy some datasets including the foreign key constraints

2006-11-27 Thread Jerry Schwartz
er 23, 2006 6:47 AM > To: Jerry Schwartz > Cc: mysql@lists.mysql.com > Subject: AW: Copy some datasets including the foreign key constraints > > Hello Jerry, > I can give you the shema of my "parent" table: > CREATE TABLE `demo_employee` (\n `idemployee` int(10) > unsi

AW: Copy some datasets including the foreign key constraints

2006-11-23 Thread Eidner, Fabian
rtz [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 22. November 2006 15:54 An: Eidner, Fabian; mysql@lists.mysql.com Betreff: RE: Copy some datasets including the foreign key constraints Do you know what your query looks like after variable substitution? That always helps me a lot. If you can'

RE: Copy some datasets including the foreign key constraints

2006-11-22 Thread Jerry Schwartz
7:46 AM > To: mysql@lists.mysql.com > Subject: Copy some datasets including the foreign key constraints > > 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 t

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,