I am receiving MySQL error 1265 when I try to insert records into a table and after googling this error I am no closer to understanding the problem.
Here is the error message that is returned:
Warning Code : 1265
Data truncated for column 'DATE_FIELD' at row 1
Here is the table definition:
CREATE TABLE `test`.`TIME_TABLE` ( `RECORD_NUM` INT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT 'Number of Records', `DATE_FIELD` DATE NOT NULL COMMENT 'Date of the event', `DESCRIPTION` VARCHAR( 1000 ) NOT NULL COMMENT 'Detail of the event' ) ENGINE = MYISAM COMMENT = 'This day in history' Here is a typical insert:
INSERT INTO TIME_TABLE ( DATE_FIELD, DESCRIPTION ) VALUES ('28, October 1971' , 'Great Britain launched Prospero, the first of four X-3 satellites.');
When inspecting the table the DATE-FIELD is set to ‘0000-00-00’