MySQL Workbench
http://www.mysql.com/products/workbench/ Query update 시 해결 방법 참조 : https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench
|
1 2 3 |
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 .... |
|
1 2 3 |
SET SQL_SAFE_UPDATES = 0; |
|
1 2 3 4 5 6 7 8 9 |
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%'; |