Essential Books

1411 - Bad Value for number date default etc.

suggest change

1067 This is probably related to TIMESTAMP defaults, which have changed over time. See TIMESTAMP defaults in the Dates & Times page. (which does not exist yet)

1292/1366 DOUBLE/Integer Check for letters or other syntax errors. Check that the columns align; perhaps you think you are putting into a VARCHAR but it is aligned with a numeric column.

1292 DATETIME Check for too far in past or future. Check for between 2am and 3am on a morning when Daylight savings changed. Check for bad syntax, such as +00 timezone stuff.

1292 VARIABLE Check the allowed values for the VARIABLE you are trying to SET.

1292 LOAD DATA Look at the line that is ‘bad’. Check the escape symbols, etc. Look at the datatypes.

1411 STR_TO_DATE Incorrectly formatted date?

Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

Error Codes:
* Error code 1064 Syntax error
* Error code 1175 Safe Update
* Error code 1215 Cannot add foreign key constraint
* 1411 - Bad Value for number date default etc.
* Access denied
* impossible position in Replication
* Cannot connect
* 144 145
* 139
* 1366
* 1062 24
Table Of Contents