What is the impact of ignoring MySQL warning messages?

Question

Below is the CREATE TABLE statement used to create my table:

CREATE TABLE IF NOT EXISTS `data_received` (
  `id` int(10) unsigned NOT NULL,
  `date_received` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `edit_time` datetime NOT NULL
}

Below is how data is saved in the table upon INSERT, if 'edit_time' value is not provided:

id   date_received         edit_time
1    2012-10-12 12:15:46   0000-00-00 00:00:00

Additionally, I get this warning message: Warning: #1264 Out of range value for column 'edit_time' at row 1

• So, my question is, is there any impact of ignoring this warning message?
• I am expecting 10 to 15 rows to be inserted every minute. So, will there be any performance degradation?
• Is there anything I can do to stop this warning message from occurring?

Answer 1

When MySQL stores a value in a numeric column that is outside the permissible range of the column data type, the result depends on the SQL mode in effect at the time: If strict SQL mode is enabled, MySQL rejects the out-of-range value with an error, and the insert fails, in accordance with the SQL standard.If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the range and stores the resulting value instead.