I am trying to update a field with NULL values without success, but If I put an empty String the update works. The problem with putting an empty string is - my column field "fruitname" accepts unique values. I am using JDBC. see below what I am trying to do.
update fruits_tbl set uxservernames=concat(fruitname, \r\n'" + fruitname + "') where fruit_id=" +fruit_id)
fruit_id (INT) PRK | fruitname (VARCHAR(255) | fruitdescr VARCHAR(255)|
The fruitname column can hold a NULL value.