Re: Modifying database schema without losing data

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