读书人

asp 用ODBC 连接SQLITE,怎么获取刚插入

发布时间: 2013-06-19 10:26:41 作者: rapoo

asp 用ODBC 连接SQLITE,如何获取刚插入记录的自增ID? [问题点数:100分]
http://bbs.csdn.net/topics/390487024
[解决办法]
last_insert_rowid()试试

The last_insert_rowid() function returns the ROWID of the last row insert from the database connection which invoked the function. The last_insert_rowid() SQL function is a wrapper around the sqlite3_last_insert_rowid() C/C++ interface function
[解决办法]
应该支持啊。直接

select last_insert_rowid();

读书人网 >其他数据库

热点推荐