Inserted, Deleted Tables (Magic Tables) in MySQL

I am regular user of MS-SQL but now working on a project which has mysql as a back-end.

Please tell me that is ther开发者_如何学Pythone exists such a inserted/Deleted tables (Magic tables) in mysql which I can use inside trigger or in normal queries.

---

They are called NEW and OLD in MySQL.

NEW is the new record to be inserted or the updated data.

OLD is the deleted record, or the old data before an update.

See the documentation for creating a trigger here: http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html