How to fix ERROR 1367: Illegal value during parsing in MySQL

DESC your_table_name;
-- or
SHOW CREATE TABLE your_table_name;

-- Valid DOUBLE range:
-- -1.7976931348623157E+308 to -2.2250738585072014E-308
-- 0
-- 2.2250738585072014E-308 to 1.7976931348623157E+308

-- Instead of:
INSERT INTO my_table (double_col) VALUES (999999999999999999E309);

-- Use a value within range:
INSERT INTO my_table (double_col) VALUES (1.5E+10);

-- Instead of implicit conversion:
SELECT numeric_string + 5;

-- Use explicit CAST:
SELECT CAST(numeric_string AS SIGNED) + 5;

-- Common CAST targets:
CAST(value AS BINARY)
CAST(value AS CHAR)
CAST(value AS DATE)
CAST(value AS DATETIME)
CAST(value AS DECIMAL(10,2))
CAST(value AS SIGNED)
CAST(value AS UNSIGNED)

-- Wrong (passing a variable with POINT data):
SET @point = POINT(10, 20);
SET @line = LINESTRING(@point, POINT(30, 40));
-- ERROR 1367: Illegal non geometric value found during parsing

-- Correct (building geometry directly):
SET @line = LINESTRING(POINT(10, 20), POINT(30, 40));

-- Or use ST_ functions:
SET @line = ST_LineString(POINT(10, 20), POINT(30, 40));

-- Check current SQL mode:
SELECT @@sql_mode;

-- Set strict mode (MySQL 5.7+):
SET GLOBAL sql_mode = "STRICT_TRANS_TABLES,STRICT_ALL_TABLES";

-- Or in my.cnf:
[mysqld]
sql_mode="STRICT_TRANS_TABLES,STRICT_ALL_TABLES"

-- Test your INSERT/UPDATE:
INSERT INTO my_table (double_col) VALUES (1.5E+10);

-- Or test your SELECT with proper casting:
SELECT * FROM my_table WHERE id > CAST("100" AS UNSIGNED);

SET GLOBAL general_log = "ON";
SET GLOBAL log_output = "TABLE";
SELECT * FROM mysql.general_log;
SET GLOBAL general_log = "OFF";