develog

SELECT TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION AS 순번, COLUMN_NAME AS 컬럼명, COLUMN_COMMENT AS 컬럼한글명, ( CASE WHEN DATA_TYPE = 'LONGTEXT' THEN DATA_TYPE ELSE CONCAT(DATA_TYPE, '(', IFNULL(CHARACTER_MAXIMUM_LENGTH, ''), ')') END ) AS 테이터타입길이, ( CASE WHEN IS_NULLABLE = 'YES' THEN '' ELSE 'NOT NULL' END ..

윈도우에서 SMB, Ping 포트를 오픈한다netsh advfirewall firewall add rule name="포트오픈 445 SMB" dir=in action=allow protocol=TCP localport=445netsh advfirewall firewall add rule name="포트오픈 ICMPv4 Ping" dir=in action=allow protocol=icmpv4:8,any

-- characterSet, collate 설정 (데이터베이스 레벨)ALTER DATABASE my_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;-- characterSet, collate 설정 (테이블 레벨)ALTER TABLE my_table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;-- characterSet, collate 설정 (컬럼 레벨)ALTER TABLE my_column MODIFY column_name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;