MySQL – Vertical Partitioning Table of content The MySQL Partitioning is used to divide large tables into smaller partitions that are stored in different physical locations and are treated as separate tables. Even though the smaller partitions are managed individually, they are still part of the main table. There are two forms of partitioning in […]
Category Archives: mysql
MySQL – Transactions Table of content The MySQL Transactions The MySQL transaction is a sequential group of database manipulation operations, which is performed as if it were one single work unit. In other words, a transaction will never be complete unless each individual operation within the group is successful. If any operation within the transaction […]
MySQL – Handling Duplicates Table of content Tables or result sets in a database usually contain duplicate records. While duplicates are generally allowed, there are situations where it is necessary to prevent them. In such cases, it becomes essential to identify and remove duplicate records from a database table. Importance of Handling MySQL Duplicates There […]