When I am running the query in MySQL from Linux server I got the error i.e

Truncated incorrect DOUBLE value: 'null' 
Same query run in MySQL from Windows server it was working.

UPDATE st_master_store_addressdtls smsa 
INNER JOIN tt_store_addressdtls tsa ON tsa.master_store_address_id=smsa.`STORE_ADDRESS_ID`
SET mast_store_is_active='D' 
WHERE tsa.godown_deletion_status='D' AND MAST_store_license_id_FK='52846';

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.