Copying data from Data View - replace NULL
已回答
Very often I copy the data from the Data View in order to, for example, use it as an input for some data modelling tests but the problem I have is that the NULLs are empty, so the data may look like this:

What I do later on is that I use multi-line editing in VSCode to add '' single quotes, casting, new lines, and aliases. The problem is that empty causes problems.
Is there a way to say that we want the SQL nulls to be replaced with a string NULL when copying data?
请先登录再写评论。
Yes, you can go here File | Settings | Database | CSV Formats -> Select your format and define 'Null value text' - this field is editable.