'분류 전체보기'에 해당되는 글 691건
- 2021.06.23 windows, linux curl 한글
- 2021.06.22 windows10 , 확장자 표시
- 2021.06.22 eclipse, multi project ctrl shift r
- 2021.06.17 curl, bash variable
- 2021.06.16 eclipse, console redirect log file
- 2021.06.11 spring, ResponseBodyAdvice
- 2021.06.11 mysql, procedure, while
- 2021.06.10 spring, @value annotation
- 2021.06.09 reactor, Scheduler elastic
- 2021.06.09 mysql, in clause order
multi project 에서
1) ctrl + shift + r 창에서 입력하는 곳 오른 쪽 위 |(점 3개) 클릭
후 두 항목 선택
show status line
show derived line
https://lifeonguide.tistory.com/47
2) parent 폴더에서
속성 > resource > resource filter
에서
children 폴더 적용
https://goni9071.tistory.com/362
Within the parent project, child ones were already visually hidden in my case, but still found through search and Ctrl-click links.
I solved this by using Resource filters:
- Right-click (parent) project > Properties > Resource > Resource Filters
- Click Add Filter..., select Applies to -> Folders and enter one child project's folder name, click OK
- Repeat 2. for all child project folders
By the end, you should have something like this:
curl -X POST -H 'Content-type: application/json' --data '{"text": "'"${message}"'"}'
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)