MySQL Workbench – AuctionPro

http://www.mysql.com/products/workbench/

Query update 시 해결 방법
참조 : https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench


You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option ....

You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option ....


SET SQL_SAFE_UPDATES = 0;

SET SQL_SAFE_UPDATES = 0;


UPDATE wp_posts
SET 
    post_content = REPLACE(post_content,
        'http://auctionpro.co.kr/',
        'https://auctionpro.co.kr/')
WHERE
    post_content LIKE '%http://auctionpro.co.kr%';

UPDATE wp_posts

SET

post_content = REPLACE(post_content,

'http://auctionpro.co.kr/',

'https://auctionpro.co.kr/')

WHERE

post_content LIKE '%http://auctionpro.co.kr%';