MySql8 Quetion: How to change a REF (integer) field value to 'null' with a DB Update Action?

Hi all,

I’ve tried a few variations such as NULL, null, ‘’ and blank - but I get the following error:

"update connected_appssetoutreach= 'null' whereid = 1 - ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect integer value: 'null' for column 'outreach' at row 1"

Has anyone been able to do this previously and can point me in the right direction?

UPDATE:
Solved, I didn’t notice the ON DELETE option in DB Manager. This solved this.

Community Page
Last updated: