How to modify a database ? #3901
-
|
Hi, Specifically, all the cells in a column must have the same expression; only some do. I would like this to be the case for all the cells. Thanks for your help! |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments
-
|
@Fred02840 For changing all of the values in a column to the same value, you can probably use this SQL in the You'll need to change the And make sure you take a complete backup of your SQLite database file first, as there is no undo, and it might take a few attempts for you to get it doing what you want. 😄 |
Beta Was this translation helpful? Give feedback.
-
|
Thank a lot, @justinclift! That's work! |
Beta Was this translation helpful? Give feedback.
@Fred02840 For changing all of the values in a column to the same value, you can probably use this SQL in the
Execute SQLtab.You'll need to change the
tablename,column_name, andnew_valueitems in the below snippet before running it.And make sure you take a complete backup of your SQLite database file first, as there is no undo, and it might take a few attempts for you to get it doing what you want. 😄