Azzera filtri
Azzera filtri

Using mysql function in code

1 visualizzazione (ultimi 30 giorni)
Jeff
Jeff il 10 Mar 2014
Modificato: Dhanyatha il 2 Lug 2014
Is it possible to perform mysql functions like last_auto_increment to determine the last value for the auto increment column in a table? After inserting a new row I have to perform a lookup of the new row to get it's id. Would certainly be nice to grab this without the extra steps?

Accedi per rispondere a questa domanda.

Risposte (1)

Dhanyatha
Dhanyatha il 2 Lug 2014
Modificato: Dhanyatha il 2 Lug 2014
You can refer to the workaround mentioned here to retrieve the last generated auto_increment field. This should help you to look up the newly inserted row.

Categorie

Scopri di più su Database Toolbox in Help Center e File Exchange

Tag

Prodotti

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by