LMSouq
database Open

MYSQL Truncated incorrect DOUBLE value

EM
Emanuel
1 month ago
3 views
Problem Description
When the SQL query below is executed: UPDATE shop_category SET name = 'Secolul XVI - XVIII' AND name_eng = '16th to 18th centuries' WHERE category_id = 4768 The following error is raised: 1292 - Truncated incorrect DOUBLE value: 'Secolul XVI - XVIII' How to fix this? --- `shop_category` table structure: category_id mediumint(8) name varchar(250) name_eng varchar(250)

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base