Re: Stored procedure that safely increments a column
From: Axel Schwenke <axel.schwenke_at_gmx.de>
Date: Wed, 24 Jul 2019 14:06:24 +0200
Message-ID: <qh9hk0$2hf$1_at_dont-email.me>
Date: Wed, 24 Jul 2019 14:06:24 +0200
Message-ID: <qh9hk0$2hf$1_at_dont-email.me>
On 23.07.2019 22:39, vjp1610_at_gmail.com wrote:
> How to run this procedure to get an incremented number
What do you mean *this* procedure? You didn't show a procedure.
MySQL has the AUTO_INCREMENT feature to generate a unique running number. MariaDB additionally has native SEQUENCE objects:
https://mariadb.com/kb/en/library/sequence-overview/
Normally there is no need to encapsulate this into a stored procedure. Received on Wed Jul 24 2019 - 14:06:24 CEST