MySQL – Delete Duplicate Records Table of content The MySQL Delete Duplicate Records Duplicate records in a database, including MySQL, is a very common occurrence. A MySQL database stores data in the form of tables consisting of rows and columns. Now, a record is said to be duplicated when two or more rows in a […]
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 […]