MySQL

Warning Code : 1265

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Dec 2007

Posts: 51

Reputation: rouse is an unknown quantity at this point

Solved Threads: 1

rouse

Offline

Junior Poster in Training

Warning Code : 1265

28 Days Ago

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:

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
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:
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:

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
INSERT INTO TIME_TABLE ( DATE_FIELD, DESCRIPTION ) VALUES ('28, October    1971' , 'Great Britain launched Prospero, the first of four X-3 satellites.');
INSERT INTO TIME_TABLE ( DATE_FIELD, DESCRIPTION ) VALUES ('28, October    1971' , 'Great Britain launched Prospero, the first of four X-3 satellites.');