Re: Common Pattern for parent-child INSERTs?

2012-01-05 Thread Johan De Meersman
http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html If you use InnoDB for your tables, you can use the ON UPDATE CASCADE option for your foreign key constraints. However, your habit is indeed a nasty one :-p It forces you to do joins where none are necessary, thus needles

ANN: PHP Generator for MySQL 11.12 released

2012-01-05 Thread SQL Maestro Team
Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 11.12, a powerful GUI frontend that allows you to generate feature-rich CRUD web applications for your MySQL database. http://www.sqlmaestro.com/products/mysql/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ PHP Genera