Dumping data to file with combined inserts.
Answered
Currently, every row of data will be exported as separate query. This is slow! Is it possible to export into single query?
Please sign in to leave a comment.
@Tauri Toompalu Could you specify database you work with?
MySQL
It's possible. Please read this tutorial about custom exports: https://blog.jetbrains.com/datagrip/2017/11/08/export-data-in-any-way-with-intellij-based-ides/
And use this extractor: https://gist.github.com/leo-from-spb/ec438f1fe9995b910ad816aabe47dd4f
It is also possible to program my own IDE for working with databases but what am I paying you for then? It is so trivial feature which should be implemented into the software from the get-go.
Plase follow: https://youtrack.jetbrains.com/issue/DBE-5187