¿ªÔÆÌåÓý

  1. GroupManagersForum
  2. Messages
Single Messages Topics Expanded Polls

Re: Change multiple rows in one column in database

 

¿ªÔÆÌåÓý

?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@...>:

?
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
Join [email protected] to automatically receive all group messages.