MobileRead Forums - View Single Post - bulk copy from one column to another: is it ok to delete original column?

ownedbycats · 10-22-2023, 07:52 PM

Yes. My usual method of 'changing' column-type (since you can't actually do that) is this:

1. Create #columnname2 with the desired type.
2. Run a search & replace to copy the contents of #columnname to #columnname2.
3. Confirm the contents are correct. (One example: If you're copying a datetime column, you need to use raw_field to preserve the exact timestamp.)
4. Delete #columnname. Restart.
5. Rename #columnname2 to #columnname.

10-22-2023, 07:52 PM	#3
ownedbycats Custom User Title Posts: 10,664 Karma: 74166147 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Yes. My usual method of 'changing' column-type (since you can't actually do that) is this: 1. Create #columnname2 with the desired type. 2. Run a search & replace to copy the contents of #columnname to #columnname2. 3. Confirm the contents are correct. (One example: If you're copying a datetime column, you need to use raw_field to preserve the exact timestamp.) 4. Delete #columnname. Restart. 5. Rename #columnname2 to #columnname. Last edited by ownedbycats; 10-22-2023 at 07:56 PM.