How to enter null INT value into MySQL database?

Questions
#1

Hey, first time posting here. I’m trying to insert rows into a MySQL database. However, n8n gives me an error when i enter data into an INT column if the value is null. This only occurs with INT columns, strings work fine even when no value exists. Anyone know how to allow INT values if there is a chance some values will be null? I’m using a set node to set the values prior to inserting to MySQL.

ERROR: Incorrect integer value: ‘’ for column ‘trz_group_id’ at row 1

#2

Hi @Gabe_Potter ,
welcome to the community :tada:

I created a sample workflow using our Function Node to delete a value that is not an integer.

image
image1561×565 51 KB

Example Workflow

Does this resolve your issue?

2 Likes
#3

Thanks for the example Marcus, very helpful! I’ll give this is a shot :ok_hand: