maria-developers team mailing list archive

[jerome brauge <j.brauge@xxxxxxxxxxx>]

Hello Alexander,
Nice to hear you again.
You can find description here :
https://mariadb.com/kb/en/sql-99/positioned-update-statement/
https://mariadb.com/kb/en/sql-99/positioned-delete-statement/

I attached an example (positioned_update.sql).
It's a useful feature to update or delete rows in a table without unique key and lock all records when cursor is open.

Regards,
Jérôme.


> -----Message d'origine-----
> De : Alexander Barkov [mailto:bar@xxxxxxxxxxx]
> Envoyé : vendredi 10 mars 2017 11:24
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@xxxxxxxxxxxxxxxxxxx)
> Objet : Re: bb-10.2-compatibility - Updatable cursor
> 
> Hello Jerome,
> 
> can you please give examples?
> 
> Thanks!
> 
> 
> On 03/08/2017 07:33 PM, jerome brauge wrote:
> > Hello Alexander,
> >
> > Can you add a task for updatable cursor  (for positioned update and
> delete).
> >
> >
> >
> > Regards,
> >
> > Jérôme.
> >

Attachment: positionned_update.sql
Description: positionned_update.sql