목록분류 전체보기 (74)
메모장
-- SELECT 한번 더 해줌SELECT SEQFROM (SELECT COALESCE(SEQ, 0) + 1 AS SEQ FROM tablename) AS t
for (Map map : mapList) { for (Map.Entry elem : map.entrySet()) { System.out.println(elem.getKey() + " : " + elem.getValue()); }}
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyyMMddHHmmss");String a = "20240710090000";// String to LocalDateTimeLocalDateTime b = LocalDateTime.parse(a, formatter);// LocalDateTime to StringString c = b.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));
https://developers.kakao.com/https://devtalk.kakao.com/// index.html// kakao// Main.vue X facebook naver web copy
SET block_encryption_mode = 'aes-256-cbc';SET @key_str = ENCRYPT_KEY;SET @init_vector = ENCRYPT_IV;// 암호화SELECT TO_BASE64(AES_ENCRYPT(필드, @key_str, @init_vector)) FROM 테이블;// 복호화SELECT AES_DECRYPT(FROM_BASE64(필드), @key_str, @init_vector) FROM 테이블;