On Mon, 28 Sep 2020, Adrian Klaver wrote:
You could use INSERT INTO location(new_fields,) SELECT the_fields FROM the_table(s).
Well, duh! I could have thought of that. That's exactly what I'll do: Create the new table, move data from the old table into it, then drop columns in the old table ... after checking all data's there. Thanks, Adrian. Stay well, Rich
