Deal with gammu and mysql make learn more about mysql feature in mysql 5.0 called trigger.

Books always good to start with so I choose MySQL Stored Procedure Programming book to start with but others might help to for someone looking for practical solution in cookbook form etc :

1. High Performance MySQL: Optimization, Backups, Replication, and More
2. MySQL Cookbook
3. MySQL Stored Procedure Programming
4. MySQL in a Nutshell (In a Nutshell (O’Reilly))
5. MySQL Administrator’s Bible (Bible (Wiley))
6. Understanding MySQL Internals

Looking around in google make me find some interesting links around trigger in mysql, here the list :

• A Tutorial on Database Concepts, SQL using MySQL, basic concept including terms.
• MySQL Triggers Tryout, Onlamp explain it with sample.
• Creating Triggers, tips for creating trigger.
• MySQL Triggers Tutorial, more detail explanation of mysql trigger line per line.
• MySQL Triggers, Auto-generate additional information in the database.
• MySQL triggers, case study.
• How To Use Triggers to Track Changes in MySQL, more advance sample.
• MySQL Triggers: How do you abort an INSERT, UPDATE or DELETE with a trigger?
• A Little MySQL Trigger Manage Tool
• Handling UPDATE errors in MySQL triggers

Wew, a lot of example but for deliver due project I’ll use cron. Once I get the point I’ll try out trigger 🙂