![[My SQL] With Recursive CTE(Common Table Expression)???](https://waterloomath.com/storage/blog/01KMWZ3H7ZYX74S22518SMW6SS.png)
When you have one table for all of codes in your system, it is often to have unique_code and parent code in that table. It enables to track down hierarchical structure of codes to see who is parent…
Blog
Articles and updates about anything.
When needed, snapshot backups of MySQL instance are not that useful. So, I tend to backup my DB with mysqldump. The script below dump all of schemas including system tables, users and privileges. It…