MySQL Security

The Database Programmer: Approaches to "UPSERT"

Posted on 30. Jun, 2009 by admin in MySQL

Alas, MySQL giveth, and MySQL taketh away. You cannot code your own UPSERT in MySQL because of an extremely severe limitation in MySQL trigger rules. A MySQL trigger may not affect a row in a table different from the row originally …

View original post here:
The Database Programmer: Approaches to "UPSERT"

Tags: body, causes-the-original, db, default-branch, extremely-annoying, from-the-row, MySQL, not-affect, postgres, table-different, trigger-may, your-own