Recognizing and setting of NULL values in table editor
已回答
Within the "Database Tools and SQL" plugin of PyCharm I opened a table in the editor, so all columns and rows are shown in a spreadsheet like way. Unfortunately, cells with the value NULL look exactly the same as cells with an empty string. And when editing these cells, I can enter arbitrary values, yet I cannot explicitly set the value to NULL. I couldn't find any option to alter this behavior in the Tools → Database → Data Views preference pane.
How can I work with NULL values?
请先登录再写评论。
On nullable columns there is 'Set NULL' action available from the context menu:
If you are working with dates in MySQL, please see DataGrip FAQ for the MySQL shows NULL instead of '0000-00-00 00:00:00' in datetime field. Why? question.
Issue is created: https://youtrack.jetbrains.com/issue/DBE-7980