Why not just swap the columns around? UPDATE archive SET outHumidity=inHumidity, inHumidity=outHumidity;
Then drop and rebuild the daily summaries. -tk On Sat, Apr 18, 2020 at 10:03 AM Steve Preston <stevepr2...@gmail.com> wrote: > I just realized that I imported a few years of data from WLK files where I > accidentally swapped the inside vs outside humidity (a bug which is now > fixed in my wlkReader app). > So now I would like to update these values in the database. > > Does wee_import "update" records which match the timestamp of existing > records in the database or does it only ADD new records? I'm assuming that > it only adds records. So I suspect that I will need to remove all the > historical WLK data from my WeeWx database, then import the correct data > again. Does this make sense? > > Thanks > Steve > > -- > You received this message because you are subscribed to the Google Groups > "weewx-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to weewx-user+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/68aa3172-cce9-4b8b-8a3f-f872dbba1cb5%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/68aa3172-cce9-4b8b-8a3f-f872dbba1cb5%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEAjRxiah8H%3DAu0G%3DByHGBeAuJXyww_u3yGYpi-hABR_pw%40mail.gmail.com.