MySql에서 다음과 같은 쿼리문에 대한 SafeMode 블록이 걸릴때, 14:11:13delete from dprc_rto where DPRC_RTO_SEQ like 23Error 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 and reconnect.0.000 sec 아래와 같이 수행하면 됩니당~SET SQL_SAFE_UPDATES = 0;delete from dprc_rto where DPRC_RTO_SEQ like 23;..
생성하기 DELIMITER $$ DROP PROCEDURE IF EXISTS input$$CREATE PROCEDURE input()BEGIN DECLARE val INT DEFAULT 0; WHILE val < 9999 DO INSERT INTO `dprc_rto`(BIZTYPE_CAT, BIZTYPE_DIV, BIZTYPE_SEC, PASS_YY_DPRC_RTO, RGT_DTM) VALUES (val, val, val, 1, NOW()); SET val = val + 1; END WHILE;END $$ DELIMITER $$ CALL input; //프로시저 호출 CREATE PROCEDURE input() 수정하기 USE `vas`;DROP procedure IF EXISTS `input`; DEL..
server.xmlURIEncoding="UTF-8" 추가 -------------------------------------------------------------------------------------------------- web.xml jsp org.apache.jasper.servlet.JspServlet fork false xpoweredBy false javaEncoding UTF8 3 볼드처리 부분 추가. setCharacterEncodingFilter org.apache.catalina.filters.SetCharacterEncodingFilter encoding UTF-8 true 주석해제 setCharacterEncodingFilter /* 주석해제 1. POST 전송시 한글깨..