Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql error 1175

-- [SOLUTION]
SET SQL_SAFE_UPDATES = 0;

-- -----------------[REASON]-----------------------------------
-- MySql session has the safe-updates option set. 
-- This means that you can't update or delete records without specifying
-- a key (ex. primary key) in the where clause.
---------------------------------------------------------------
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #sql #error
ADD COMMENT
Topic
Name
3+8 =