Edit multiple columns

I hope i'm on the right forum.

I'm using Datagrips to browse the information in my database, and I can't find the way to edit multiple rows at once. So for example I have a Partners table and a registration_type_id column. I want to set the status of all the partners to '1' but if I select all the status cells, and type '1' then only the last one selected will change value. Is there a way to do this from the gui? 

Comment actions Permalink

Hello, please tell me DataGrip version you are running. Just checked  latest 2019.3.3 and this works as expected, you select multiple rows, type a value and it appears in all selected cells.

Comment actions Permalink

I have the same problem for integer rows. For text it works as before.

IntelliJ IDEA 2019.3.3 (Ultimate Edition)
Build #IU-193.6494.35, built on February 11, 2020
Runtime version: 11.0.5+10-b520.38 amd64
VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
Linux 5.5.7-1-MANJARO

Comment actions Permalink

Can you please tell us which database you are using and send a DDL for a table where you have this issue?

Comment actions Permalink

PostgresSQL 9.6/12 

Here's the sample DLL, I cannot modify the season/episode column in bulk.

-- auto-generated definition
create table files
id bigserial not null
constraint files_pkey
primary key,
title varchar(256) not null,
size bigint,
"season" integer,
"episode" integer,
"createdAt" timestamp with time zone not null,
"updatedAt" timestamp with time zone not null

create index files_season_episode
on files ("season", "episode");```
Comment actions Permalink

I checked on DataGrip 2020.01, it works for columns that have string values, but for integer columns it does not. Here's a DDL for a table I can't edit: 


create table clients
id bigint unsigned auto_increment
primary key,
name varchar(100) not null comment 'Client name',
name_kana varchar(100) not null comment 'Client kana name',
industry_type_id tinyint unsigned not null comment 'Client industry type',
last_day_to_charge tinyint unsigned null,
pay_in_month_id tinyint unsigned not null,
last_day_to_pay tinyint unsigned null,
api_link_senses varchar(255) null comment 'Api link',
number_of_employees int unsigned null comment 'Number of employees for this Client',
stock_status_id int unsigned default 1 not null comment 'Status of the stock for this Client''s company',
charge_type tinyint unsigned not null,
pay_type tinyint unsigned not null,
note varchar(1000) null comment 'Note for this client',
created_at timestamp default CURRENT_TIMESTAMP not null,
updated_at timestamp default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP,
deleted_at timestamp null



Columns like industry_type_id or last_day_to_charge, I have to edit row by row, which is quite troublesome. 


Please sign in to leave a comment.