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

Related Reading:

SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers)

Relational Methods in Computer Science: 6th International Conference, RelMICS 2001, and 1st Workshop of COST Action 274 TARSKI Oisterwijk, The Netherlands, October 16-21, 2001, Revised Papers

Web Dynamics: Adapting to Change in Content, Size, Topology and Use

Persistence in the Enterprise: A Guide to Persistence Technologies

Spatial Cognition V: Reasoning, Action, Interaction

• mysql trigger tutorial
• mysql trigger
• mysql trigger example
• mysql triggers tutorial
• mysql trigger examples
• trigger tutorial
• mysql create trigger
• mysql triggers
• mysql trigger sample
• create trigger mysql
• mysql advanced triggers
• triggers in mysql tutorial
• trigger example in mysql
• trigger mysql
• tutorial trigger mySQL
• trigger mysql tutorial
• database triggers tutorial
• trigger tutorial MySQL
• mysql triggers tutorials
• mysql triggers example
• MySql trigger tutorials
• MYSQL TRIGGERS EXAMPLES
• advanced mysql triggers
• mysql create trigger example
• advanced triggers mysql
• tutorial trigger
• trigger mysql abort
• mysql triggers for dummies
• trigger mysql example
• samples trigger mysql
• mysql trigger advanced
• triggers in mysql
• trigger gammu
• mysql trigger tool
• mysql triger
• Sample trigger for mysql
• mysql trigger abort insert
• sample triggers in mysql
• trigger example mysql update
• trigger in mysql example
• sample trigger in mysql
• TRIGGER EXAMPLES IN MYSQL
• trigger in mysql
• mySql triger tutorial
• MySQL advanced TRIGGER
• mysql advance trigger
• triggers in mysql examples
• mysql trigger tuto
• create trigger in mysql
• create triggers in mysql