UPDATE FOOD_WAREHOUSE SET FREEZER_YN = 'N' WHERE FREEZER_YN IS NULL;
SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS, FREEZER_YN FROM FOOD_WAREHOUSE ORDER BY WAREHOUSE_ID;
UPDATE command denied to user 'USER477690B76A6BE7122B5F00FCE2'@'172.31.27.227' for table 'food_warehouse'
가 발생한다.
코테에서는 당연히 원본데이터를 조회만할 수 있기때문에 권한이 없다.
다른 방법으로 진행해야한다.
SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS, IFNULL(FREEZER_YN,'N') AS FREEZER_YN FROM FOOD_WAREHOUSE WHERE ADDRESS LIKE '경기도%'ORDER BY WAREHOUSE_ID;
IFNULL(컬럼, NULL일때 변경하고싶은 값)
사용