MYSQL Truncated incorrect DOUBLE value

by

You don’t need the AND keyword. Here’s the correct syntax of the UPDATE statement: 

UPDATE 
    shop_category 
SET 
    name="Secolul XVI - XVIII", 
    name_eng = '16th to 18th centuries' 
WHERE 
    category_id = 4768

More Related Contents:

  1. Why do I get an error from this sub query script?
  2. sql query to modify the selected value from database [closed]
  3. how to get similar search results in MySQL?
  4. How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?
  5. Can I concatenate multiple MySQL rows into one field?
  6. Disable ONLY_FULL_GROUP_BY
  7. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  8. How to do the Recursive SELECT query in MySQL?
  9. MySQL, update multiple tables with one query
  10. How do I see all foreign keys to a table or column?
  11. Do different databases use different name quote?
  12. MySQL case sensitive query [duplicate]
  13. What does mysql error 1025 (HY000): Error on rename of ‘./foo’ (errorno: 150) mean?
  14. How do I change the data type for a column in MySQL?
  15. mysql fulltext search failure
  16. Adding a leading zero to some values in column in MySQL
  17. Using SQL to determine word count stats of a text field
  18. Update one MySQL table with values from another
  19. MySQL Order before Group by
  20. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  21. Export a MySQL Database to SQLite Database
  22. “193: %1 is not a valid Win32 application” bug with a new Rails Application
  23. How to display open transactions in MySQL
  24. SQL search multiple values in same field
  25. Removing duplicates with unique index
  26. MySQL – Select the last inserted row easiest way
  27. Getting number of rows inserted for ON DUPLICATE KEY UPDATE multiple insert?
  28. MySQL query, MAX() + GROUP BY
  29. Convert JSON array in MySQL to rows
  30. ALTER table – adding AUTOINCREMENT in MySQL

Leave a Comment