MySQL – Cursors Table of content The MySQL Cursors A MySQL cursor is a pointer that is used to iterate through a table”s records. They are used within stored programs such as procedures and functions and have the following features − READ ONLY − Cursors only allow you to read data; you can”t make changes […]
Category Archives: mysql
MySQL – Sequences Table of content A sequence is a series of integers, starting from 1 and incrementing by 1 with each successive value. These sequences are usually used in databases, as many applications require each row in a table to have a unique identifier, and sequences provide an easy way to generate such values. […]
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 […]