๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

MySQL1

[MySQL] MySQL safe mode ํ•ด์ œ - Error Code : 1175 MySQL safe mode ํ•ด์ œ - Error Code : 1175 ๊ฐœ๋ฐœํ™˜๊ฒฝ macOS Monterey ver 12.5 MySQLWorkbench ver.8.0.25 ์—๋Ÿฌ ๋ฐœ์ƒ ๋Œ€๋žต ์•„๋ž˜ ๊ฐ™์€ ์ฟผ๋ฆฌ์™€ ๊ฐ™์ด, ํ•œ ์กฐ๊ฑด์œผ๋กœ ์—ฌ๋Ÿฌ ๊ฐœ์˜ records๋ฅผ ํ•œ๊บผ๋ฒˆ์— ์—…๋ฐ์ดํŠธํ•˜๋ ค๊ณ  ํ•˜๋‹ˆ ํ•ด๋‹น ์—๋Ÿฌ๋ฅผ ๋งŒ๋‚ฌ๋‹ค. update boards set del = 1 where ref = 1; Error Code : 1175. 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 in Preferences -> SQL Editor.. 2022. 7. 29.
728x90

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”