This is a nicer shortcut than the stored procedures, but it has two downsides (which were mentioned in the original post): 1. You need to declare the RULE for every table seperately. 2. The RULE converts _every_ INSERT to a REPLACE (or an ignore). You cannot easily flip between normal inserts, insert-ignore and replace on the same table.
Re: this may be an alternative
1. You need to declare the RULE for every table seperately.
2. The RULE converts _every_ INSERT to a REPLACE (or an ignore). You cannot easily flip between normal inserts, insert-ignore and replace on the same table.