I understand why you thought a sentence would be necessary DELETE. But note that the verb in the statement applies to the record, not to an individual field. And since your intention is not to delete ( DELETE) the record, but to update the record by emptying a field, then the verb to use is UPDATE:
update persona
set valor = null
where id = 3
Of course, this assumes that your column valoris configured to accept values NULL.
I understand why you thought a sentence would be necessary
DELETE
. But note that the verb in the statement applies to the record, not to an individual field. And since your intention is not to delete (DELETE
) the record, but to update the record by emptying a field, then the verb to use isUPDATE
:Of course, this assumes that your column
valor
is configured to accept valuesNULL
.