MySQL Workbench从CSV导入NULL [英] MySQL Workbench Import NULL from CSV
问题描述
我一辈子都无法使MySQL Workbench为CSV中的空白单元格导入NULL.
I can't for the life of me make MySQL Workbench import NULL for blank cells in a CSV.
我尝试过:
- 空白
- NULL
- \ N
- 带有和不带有"的每个
如何通过我想通过Workbench导入MySQL的CSV文件中的一个单元格为'null'?
How the does one signify a cell is 'null' inside a CSV file I want to import into MySQL via Workbench?
推荐答案
自MySQL Workbench 8.0.16版本(于04/25/2019发行)以来,还有一个用于上传.csv文件的附加选项-"null和NULL单词作为SQL关键字".当将此选项选择为YES时,.csv文件中没有引号的NULL表达式(,NULL,而不是" NULL,)将用于此目的.
Since MySQL Workbench version 8.0.16 (released on 04/25/2019) there has been an additional option for uploading .csv file -- "null and NULL word as SQL keyword". When selecting this option as YES, the NULL expression without quotes in .csv file (,NULL, rather than ,"NULL",) will work for this purpose.
这篇关于MySQL Workbench从CSV导入NULL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!