Using mysql function in code

6 ビュー (過去 30 日間)
Jeff
Jeff 2014 年 3 月 10 日
編集済み: Dhanyatha 2014 年 7 月 2 日
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?

サインインしてこの質問に回答する。

回答 (1 件)

Dhanyatha
Dhanyatha 2014 年 7 月 2 日
編集済み: Dhanyatha 2014 年 7 月 2 日
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.

カテゴリ

Help Center および File Exchange で Database Toolbox についてさらに検索

タグ

製品

Community Treasure Hunt

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

Start Hunting!

Translated by