Datainsert table with NaN values into SQL table as NULLs

5 次查看（过去 30 天）
Olivia
Olivia 2016-8-15
评论： Ledger Yu 2019-1-8
Dear Sir/Madam,
I have a matlab table with 2 numeric columns. Some values in the table are NaN. What is the best way to get these values to appear as NULL when inserted in SQL? I have been using datainsert and repeatedly get errors, even though NullNumberWrite='NaN'.
Any help would be much appreciated.

请先登录，再回答此问题。

回答（1 个）

Bhavesh Bhatt
Bhavesh Bhatt 2016-8-16
I hope this helps -
a=[NaN,1,2,3,NaN,2,3,4,3,4,4,4,4,5,32]';
To delete the NaN entry, please type the following commands in the MATLAB command window -
>> a(isnan(a))=[];
To replace the NaN entry with 0, please type the following commands in the MATLAB command window -
>> a(isnan(a))= 0;
  1 个评论
Ledger Yu
Ledger Yu 2019-1-8
OP is asking about how to insert those rows with NaN values, not removing them or replacing them. Those NaN values should still be inserted.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by