Wednesday, January 8, 2020

Update query failing with error in MySQL Workbench

Follow the following steps before executing the UPDATE command: In MySQL Workbench

    Go to Edit --> Preferences
    Click "SQL Editor" tab and uncheck "Safe Updates" check box
    Query --> Reconnect to Server // logout and then login
    Now execute your SQL query

or

SET SQL_SAFE_UPDATES = 0;

No comments:

Post a Comment

Mixed Content: The page at xxx was loaded over HTTPS, but requested an insecure

 Mixed Content: The page at ' https ://www.test.com/signup.aspx' was loaded over HTTPS, but requested an insecure script ' http ...