Using mysql function in code

1 view (last 30 days)
Jeff
Jeff on 10 Mar 2014
Edited: Dhanyatha on 2 Jul 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?

Sign in to answer this question.

Answers (1)

Dhanyatha
Dhanyatha on 2 Jul 2014
Edited: Dhanyatha on 2 Jul 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.

Categories

Find more on Database Toolbox in Help Center and File Exchange

Tags

Products

Community Treasure Hunt

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

Start Hunting!