I searched the web hours for this but now I have to ask.
How can I set values to NULL if there are empty? When I try to execute
I get the error "Exception: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'heartrate' at row 1" because heartrate is an empty string. How can I set it automatically to NULL?