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 – Stored Functions Table of content MySQL Stored Functions A Stored Function is a set of SQL statements that perform a specific operation and then return a single value. Similar to built-in functions in MySQL, a stored function can be called from within any MySQL statement. The MySQL CREATE FUNCTION statement is used to […]
MySQL – SIGNAL Statement Table of content When working with MySQL stored procedures, managing exceptions is important to prevent abrupt termination of procedures and to provide meaningful error information. This is achieved using the MySQL SIGNAL statement and the DECLARE … HANDLER statement. The MySQL SIGNAL Statement The MySQL SIGNAL statement is used to convey […]