issue with update on table and prepared statement
I am having an issue updating a table using a preparedstatement in MySQL 5.5.
I have the following table
Here is the query I send to to the prepared statement (executeUpdate(query)):
UPDATE session SET notes = ? WHERE session_id = ?
When I execute the code, the notes field is updated. However, the dates in both date fields are also being changed to todays date for some reason.
Does anyone know what could possibly cause this? Thanks.