MySQL Stored Procedure for CRUD Dynamic Queries
The new MySQL 5.7 version has some great features. One of them […]
Tag: mysql
Mysql Backup Script
Features Full Backup (Mysqldump) Incremental Backup (Bin-log) Local Backup & Remote(AWS S3) Upload Sample […]
Don’t use utf8 encoding in MySQL (>= 5.5.3)
오늘날 한국어/중국어/일본어등 2바이트 문자권에서의 SW개발 및 다국어를 대비한 문자열 인코딩은 거의 UTF-8로 […]
MySQL Procedure Pattern for Nested Transaction
The MySQL dose not supports ‘Nested Transaction’. Transactions cannot be nested. This […]
MySQL, Checking the IP address in a range
fn_ipv4_match( needle, haystack ) Returns 1 if haystack contains needle. needle : IPv4 […]