RE: Copy some datasets including the foreign key constraints

2006-11-27 Thread Jerry Schwartz
_ibfk_5` FOREIGN KEY (`demo_user_iduser`) > REFERENCES `demo_user` (`iduser`) ON DELETE CASCADE ON UPDATE > CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci > > Know i'm searching an easy way to copy the "parent" table an > all his childs but with the

RE: Copy some datasets including the foreign key constraints

2006-11-22 Thread Jerry Schwartz
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 debugging the heart of our online system, and it has helped me find missing single