I don't know what I'm doing wrong. Here is what I'm doing:
I select a table and go to the 'Data' tab.
I click on a row and enter an INTEGER field.
I delete the contents of the field and then click on a different row.
The following error pops-up:
SQL Error: Incorrect integer value: '' for column 'zip' at row 1
However, the following sql code works from a command line prompt:
UPDATE table SET zip=null WHERE id=#;
Where table is the name of the table and # is the id for the record that I am updating.
Does anyone know how to enter null values using HeidiSQL? If so, is there a way to enter a null value for lots of records in one shot?