Out of range value for column 'release_d' at row 2

Asked Apr 02 '15 at 05:43

Active Apr 02 '15 at 06:02

Viewed 111 times

First time to ask a question. Will do my best to follow the tips:

UPDATE albums  
SET release_d = 1800  
WHERE release_d < 1980;

UPDATE albums  
SET release_d = '1800'         
WHERE release_d <= '1980';

I receive the error exactly as this: Out of range value for column 'release_d' at row 2 I just don't see it. Using Sequel Pro, MySQL 5.

Trying to change the year of the release date.
The possible answers found were far too complex for me.
Thanks for the kindness.

edited Apr 02 '15 at 06:02

Dyrandz Famador

asked Apr 02 '15 at 05:43

Paula

Show the ddl and sample data – Jens Apr 02 '15 at 05:49
Change your type in the database of release_d to varchar and then be sure to quote the strings. – MrTechie Apr 02 '15 at 06:07
@MrTechie: please refrain from such advice without learning details about database structure first. This could easily lead to data loss for OP. – Mchl Apr 02 '15 at 06:38
If you reference any "Out of range" on the internet it will always come back to the type – MrTechie Apr 02 '15 at 06:41
Thanks MrTechie, your advice helped. – Paula Apr 06 '15 at 18:42
Thanks Jens and xsami, I will know how to better ask a question with tables next time. – Paula Apr 06 '15 at 18:43

0 Answers0