ERROR 1264: Out of range value for column 'SOLAR_MAX' at row 1

UPDATE `aws`.`STATION_DATA` SET `SOLAR_MAX`='1500' WHERE `STATION_DATA_ID`='142' 

ERROR 1264: 1264: Out of range value for column 'SOLAR_RADIATION_MAX' at row 1

I was trying to update value in table . I got error Operation failed: There was an error while applying the SQL script to the database.

Problem solve :- table structure is it now you have change data type.

CREATE TABLE `STATION` ( SOLAR_MAX Double(5,2) );

Step 2:Two method

1. alter table STATION MODIFY COLUMN SOLAR_MAX varchar(255);

mysql> desc STATION;
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| id    | varchar(255) | YES  |     | NULL    |       |
+-------+--------------+------+-----+---------+-------+

2. alter table STATION change SOLAR_MAX SOLAR_MAX  double(10,2);

Using this command you can change type .