Search code examples
mysqlmysql-error-1064

MySQL precision DECIMAL(13,9) for longitude

I am trying to update a row in the MySQL table, the data of the column is -122.333351900 and it already exists, so there is no problem on its length not matching the data type and its length.

But when I run a UPDATE sql command it fails with 

ERROR 1264 (22003): Out of range value for column 'longitude' at row 1

I don't understand why its wrong? It already has inserted this value and now when I run an UPDATE command it fails with an error!

Solution

  • Check your table if it has a trigger on it. A trigger runs right before or after the update/insert on a table.

    If it contains an error it looks like the update is going wrong when actually a related trigger fails.