메모장

-- 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 테이블;

SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_COMMENTFROM INFORMATION_SCHEMA.COLUMNSWHERE COLUMN_NAME = [컬럼명] AND COLUMN_COMMENT = [컬럼 코멘트];