On Sat, Jan 7, 2017 at 9:27 AM, Gan Uesli Starling <g...@starling.us> wrote:
> So I'm trying to accumulate data for state/prov inside of USA, Canada and > Mexico, and country for the rest of the world. > > Since country and state from the same update are factors in incrementing > each of four tables, > You should ask yourself why you have four tables instead of one table. This (poor database normalization) is the root cause of the problem. e _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users