SQLite trigger to update Summary Counts
- by jrhicks
Consider the following two (hypothetical) tables
Temperature
* day
* time
* lake_name
* station
* temperature_f
Temperature_summary
* day
* lake_name
* station
* count_readings_over_75f
* count_readings_below_75f
How can I write an SQLite Trigger to update the temperature_summary table on insert. I want to increment the count.
Thank You,
Jeff