RE: Copy some datasets including the foreign key constraints

2006-11-27 Thread Jerry Schwartz
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) unsigned NOT NULL auto_increment,\n `demo_mandt_idmandt` int(10) unsigned

AW: Copy some datasets including the foreign key constraints

2006-11-23 Thread Eidner, Fabian
@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't dump it to the screen because it breaks too much of your system, look into syslog(). That's what I use when

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

RE: Copy some datasets including the foreign key constraints

2006-11-22 Thread Jerry Schwartz
@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 tables. The problem is, i'm using foreign key constraints between those