如何在sqlite中使用scope_identity [英] how to use scope_identity in sqlite

问题描述

当我在 sqlite 中使用 scop_identity 时遇到问题，它显示类似select"附近的错误:语法错误...我像这样编写查询

I have issue when i use scop_identity in sqlite it showing the error like near "select": syntax error...i write query like this

   string txtSQLQuery = "insert into  SerpTrak_Site (SiteName) values ('" + txturl.Text +   "')select scope_identity();";

此查询中的任何错误请帮助我...

any wrong in this query please help me...

推荐答案

SQLite 没有名为 scope_identity

SQLite does not have a function by the name scope_identity

您可能正在寻找SELECT last_insert_rowid()"

You are probably looking for 'SELECT last_insert_rowid()'

另见这个问题:SQLite 是否支持 SCOPE_IDENTITY?

这篇关于如何在sqlite中使用scope_identity的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！