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 'heart_rate' at row 1" because heart_rate is an empty string. How can I set it automatically to NULL?