![]() ![]() WHERE id IN ( which returns a single value being the PrimaryKey of the currently selected row in the table, but that only updates ONE record. WHERE id IN ('9a7be3ad-ae74-4518-9214-5fe8424f3644', '8f1ee9ea-76fe-48c1-8928-4f00c935b4d7', '8ac0ca46-35b5-409d-8921-a7f93281c374')īut how do I do it properly using the selected values? I tried this: ALTER TABLE in PostgreSQL Database Add column Rename column Modify column datatype Set or Remove default value to column Add or Drop constraint to column. If I write a manual SQL query, like this, it works: Where those values are from the "id" Primary Key column. For INSERT and UPDATE, the values are the newly inserted/. I have a table called table11 and if I select 3 rows for example, I see that "SelectedRowKeys" shows all 3 like: In PostgreSQL, the ALTER TABLE command updates the tables structure, such as adding a new column, renaming a column, changing data type, etc. Upon compilation, a RETURNING clause, or database equivalent, will be rendered within the statement. ![]() How do I mass update multiple rows from a table where I select several of them? Can't seem to get this to work. Edit: olaf answer is easiest and correct way of doing this however the below also is viable solution for most cases. I'm using the Retool PostgreSQL database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |