Using mysql function in code

1 vue (au cours des 30 derniers jours)
Jeff
Jeff le 10 Mar 2014
Modifié(e) : Dhanyatha le 2 Juil 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?

Connectez-vous pour répondre à cette question.

Réponses (1)

Dhanyatha
Dhanyatha le 2 Juil 2014
Modifié(e) : Dhanyatha le 2 Juil 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.

Catégories

En savoir plus sur Database Toolbox dans Help Center et File Exchange

Tags

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by