1. IDEs Support (IntelliJ Platform) | JetBrains
  2. Community
  3. DataGrip

DataGrip. DataEditor: Modify cells from a sql-query result with joins

Planned
Avatar
Simon
Created

In SQLyog you can choose ( vai dropdown ) which table can be modified, if you want do edit in a result of a query with joins. 

 

Is something similar possible in DataGrip?

3 comments
Avatar
vasily chernov
Created
Comment actions Permalink

@Simon,

There is an issue https://youtrack.jetbrains.com/issue/DBE-1038

0
Avatar
Simon
Created
Comment actions Permalink

Thanks for the info.

So no similar option available and no hope of an implementation in the near future. (Ticket older than 3,5 years)

1
Avatar
Simon
Created
Comment actions Permalink

this is really frustrating.

I really want to replace SQLyog. But this type of method covers to much of my daily work. Are they really no alternatives methods? 

How can i change manually fields on an amount of entries from one table, but filtered on fields on a referenced table? Please consider 'manually', an update command can be used, but is not practically for my kind of work. 

I would be thankful for any alternative method, usable in DataGrip.

3

Please sign in to leave a comment.