有没有办法在SQLite中存储一个（唯一的）数据元素？-Isthereawaytostoreaone(unique)dataelementinSQLite?

12  

For SQLite, which is an embedded database, after all, there's nothing wrong with using a single table for holding a unique value like this.

毕竟，对于SQLite来说，这是一个嵌入式数据库，使用单个表来保存这样的唯一值没有任何问题。

sqlite> CREATE TABLE AppVersion (version);
sqlite> INSERT INTO AppVersion VALUES('1.0');
sqlite> SELECT * FROM AppVersion;
1.0
sqlite> UPDATE AppVersion SET version='1.1';
sqlite> SELECT * FROM AppVersion;
1.1

It's an embedded database. You expect good performance when you use it, not perfect performance. A single extra table (holding only a single row ever) shouldn't make any difference to any reasonable application.

这是一个嵌入式数据库。您希望在使用它时获得良好的性能，而不是完美的性能。一个额外的表（只保留一行）不应对任何合理的应用程序产生任何影响。