이응기역

http://www.javabyexamples.com/quick-guide-to-responsebodyadvice-in-spring-mvc

CREATE SP_FOR_LOOP_SAMPLE(
 OUT  o_return      INT
  ,  OUT  o_row_count   INT
)
BEGIN

-- -------------------------------------
-- declare (BEGIN)
-- -------------------------------------

DECLARE v_abc VARCHAR(100) CHARSET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'RemoveApiLogBatch'; 

-- -------------------------------------
-- declare (END)
-- -------------------------------------
  

SET ii = 0;

label1: WHILE ii < v_max_cnt DO


SET @query = CONCAT (
  'DELETE FROM TEST_TABLE '
...
);

    PREPARE stmt FROM @query;
  EXECUTE stmt;
  SELECT ROW_COUNT(), LAST_INSERT_ID() INTO @row_count, @last_insert_id;
  DEALLOCATE PREPARE stmt;


IF @row_count < v_unit_cnt THEN

LEAVE label1; /* 종료 */

END IF;

  SET ii = ii + 1;

  END WHILE label1;
  
SET o_return = 0, o_row_count = @row_count;
  
END

import org.springframework.beans.factory.annotation.Value;

@Deprecated public static Scheduler elastic()

Deprecated. use boundedElastic(), to be removed in 3.5.0

Scheduler that dynamically creates ExecutorService-based Workers and caches the thread pools, reusing them once the Workers have been shut down.

The maximum number of created thread pools is unbounded.

The default time-to-live for unused thread pools is 60 seconds, use the appropriate factory to set a different value.

This scheduler is not restartable.

Returns:default instance of a Scheduler that dynamically creates ExecutorService-based Workers and caches the threads, reusing them once the Workers have been shut down

(https://projectreactor.io/docs/core/release/api/reactor/core/scheduler/Schedulers.html#elastic--)

-- in clause order
create table test111 (num int);
insert into test111 values (1);
insert into test111 values (2);
insert into test111 values (3);
insert into test111 values (4);
insert into test111 values (5);
insert into test111 values (6);
insert into test111 values (7);
insert into test111 values (8);
insert into test111 values (9);
insert into test111 values (10);
insert into test111 values (11);
insert into test111 values (12);
insert into test111 values (13);
insert into test111 values (14);
insert into test111 values (15);
insert into test111 values (16);
select * from test111;

SELECT * FROM test111
WHERE num IN (5,2,6,8,12,1)
ORDER BY FIELD(num,5,2,6,8,12,1);

(https://stackoverflow.com/questions/1869063/customised-ordering-in-sql)

find . -type f \( -name '*.java' -o -name '*.yml' \) 

select concat('query:', @query);

$ cat f.sh
curl -X POST http://127.0.0.1:8080/goods/search -H 'Content-Type: application/json'  -d '
{
 "stringdate":"2021-05-28",
 "ordercount": 2,
 "itemid": 1234
}
'

https://ykarma1996.tistory.com/86

파일 > 옵션 > 언어교정 > 자동 고침 옵션 > 한/영 자동 고침

https://dev-jaeho.tistory.com/10