'DB' 카테고리의 글 목록 (3 Page)

DB 41

show variables like 'max_connections'; t2.micro: 66 t2.small: 150 m3.medium: 296 t2.medium: 312 M3.large: 609 t2.large: 648 M4.large: 648 M3.xlarge: 1237 R3.large: 1258 M4.xlarge: 1320 M2.xlarge: 1412 M3.2xlarge: 2492 R3.xlarge: 2540

DB/MYSQL HEON.D 2022.08.05

[ MYSQL ] Safe Mode 해제

SET SQL_SAFE_UPDATES = 0;

DB/MYSQL HEON.D 2022.08.04

[ MYSQL ] 중복 검증 쿼리

SELECT user_id, count(user_id) AS total, count(distinct device_token) AS token, IF( count(user_id) != count(distinct device_token), '불일치', '일치') AS duplicated FROM USER_DEVICE AS UD GROUP BY user_id ORDER BY total DESC;

DB/MYSQL HEON.D 2022.06.14

[ MONGODB ] 기간 조회

{ createdAt:{$gte:ISODate("2021-01-01"),$lt:ISODate("2021-08-31")} }

DB/MongoDB HEON.D 2022.06.08

[ MYSQL ] 날짜 증가 후 조회

(date_sub('$date', interval '12' month) 12달 (date_sub('$date', interval '1' day) 하루 Today WHERE t_date=CURDATE(); Tomarrow WHERE t_date=CURDATE() + INTERVAL 1 DAY; Yesterday WHERE t_date=CURDATE() - INTERVAL 1 DAY;

DB/MYSQL HEON.D 2022.05.27

[ MYSQL ] DB 커넥션 정보 utf8mb4 이모지

DB CHARSET utf8mb4

DB/MYSQL HEON.D 2022.05.20

[ MYSQL ] AutoIncrement 값 초기화

ALTER TABLE NUTRIENT AUTO_INCREMENT = 원하는 숫자;

DB/MYSQL HEON.D 2022.01.13

[ MYSQL ] FULLTEXT Search

파라미터 변경 ngram_token = 2 innodb_ft_min_token_size = 2 ft_min_word_len = 2 적용확인 show variables like 'ft_min%'; show variables like 'innodb_ft_min%'; 검색 인덱스 추가 ALTER TABLE MANUAL ADD FULLTEXT(칼럼명); 조회 쿼리 SELECT 칼럼, MATCH (칼럼) AGAINST ('키워드*' IN BOOLEAN MODE) AS score FROM 테이블 ORDER BY score desc; SELECT manual_title, ( ((LENGTH(manual_title) - LENGTH((REPLACE(manual_title, '관리', '')))) / LENGTH('관리..

DB/MYSQL HEON.D 2022.01.12

[ MongoDB ] mongorestore

Mongo CLI 설치 brew tap mongodb/brew brew install mongodb-community@5.0 mongodb-database-tools는 내장되어있지만 추가 설치가 필요한 경우 brew install mongodb-database-tools Brew Install 실패하는 경우 Error: Permission denied @ apply2files - /usr/local/lib/docker/cli-plugins mkdir -p /Applications/Docker.app/Contents/Resources/cli-plugins brew cleanup mongod "error":"NonExistentPath: Data directory /data/db not found. Mac ..

DB/MongoDB HEON.D 2021.12.24