英文:
Are there specific valid table names in Sqlite
问题
我最初的打算只是尝试熟悉在 Android 中使用 Sqlite,但最终却陷入了解决一个一开始不存在的错误的困境。
我创建了一张名为 "table" 的表,但每当我尝试从表中获取数据时,应用程序就会崩溃,而且保存到表中的数据也不会被保存(但我之前并不知道)。
经过几个小时的努力尝试修复问题后,我改变了表名,然后一切都正常工作了。
我的问题是 "table" 在 sqlite 中不是一个有效的表名,就像某种关键字一样吗?如果是的话,是否有其他 SQL 关键字的链接?
英文:
I initially intended to just try and get myself familiar with the use of Sqlite in android but I ended up getting stucked trying to fix an error that doesn't exist in the first place.
I created a table with the name "table", but whenever I try to get data from the table the app crashes and moreover data saved to the table doesn't get saved(but I never knew).
After few hours of trying to fix things I changed the table name and it worked well.
My question is Is "table" not a valid Table name in sqlite like some sort of keywords if so then any link to othet sql keywords
答案1
得分: 1
是的,"table" 是 SQLite 中的一个关键字。您可以在这里查看关键字列表。此外,SQLite 关键字不区分大小写,因此键入 "table" 或任何其他关键字都表示相同的意思。
英文:
Yes table is a keyword in sqlite. You can check the keywords here. Also sqlite keywords are not case sensitive so typing "table" or any other keyword either way will mean the same thing.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论