MySQL Forums
Forum List  »  Connector/Node.js

How to insert/update with NULL value in Node.Js
Posted by: Chirag Shah
Date: November 23, 2018 02:50AM

I want to use Connector for Node.Js which is using xdevapi.
I want use following scenario.

table.insert(['name','isActive']).values([null, 1]).execute();

problem here is that I can't insert null value. It gives me error.

Error: invalid input expression
at module.exports (D:\CodeBase\GitKraken\BitBucket\MSSP\Vue\vue-apexa-portal\node_modules\@mysql\xdevapi\lib\DevAPI\Util\parseFlexibleParamList.js:43:15)
at Object.values (D:\CodeBase\GitKraken\BitBucket\MSSP\Vue\vue-apexa-portal\node_modules\@mysql\xdevapi\lib\DevAPI\TableInsert.js:106:28)
at Object.InsertData (D:\CodeBase\GitKraken\BitBucket\MSSP\Vue\vue-apexa-portal\src\server\database.js:115:8)
at <anonymous>
at process._tickCallback (internal/process/next_tick.js:188:7)

Can anyone help me with this?

Options: ReplyQuote

Written By
How to insert/update with NULL value in Node.Js
November 23, 2018 02:50AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.