Change multiple rows in one column in database
|
Dear group members,
?
Is there a possibility to change multiple rows in a column in one go? I haven't been able to find anything about this so maybe it's not possible. In one of my groups we have a database with journal holdings. Each row holds a contact e-mail address. I would like to be able to change one of the contact e-mail addresses for multiple rows. I can only see this being done one row at a time. But sometimes there can be a few hundred rows which makes it fairly undoable.?
I am grateful for your help and any suggestions.
?
Winnie |
|
On Wed, Feb 19, 2025 at 05:13 AM, Winnie wrote:
Is there a possibility to change multiple rows in a column in one go? No.? This is a very basic database setup, so everything is row based.
?
Duane
--
Lots of detailed information can be found in the Owners Manual and Members Manual. |
开云体育?Hi Winnie, There are no commands for modifying the contents of a database. The only way I can think of is to export the database to a file in either CSV or JSON format, then edit the file using any text editor (a simple find&replace operation should cover what you intend to do), then import the file into the database again, possibly to a new database. In case of JSON the import will create a new database I believe, you can delete old one after verifying that the change was successful. If you use a CSV file it will append the modified rows to the existing table, and you can delete the original ones afterwards. Thomas Am 19.02.2025 um 12:14 schrieb Winnie via groups.io <winnieschats@...>:
|
Winnie
Duane
Thomas Gruber