SQLite:“ALTER TABLE `game` ADD UNIQUE(`name`)";SQLite 中的错误 [英] SQLite:"ALTER TABLE `game` ADD UNIQUE(`name`)" Error in SQLite

问题描述

我使用了与 Mysql 中相同的命令语法，并想为 Android 设备环境中的表设置唯一键，但是，LogCat 中提示错误:

I used the same command syntax above as in Mysql and would like set a unique key for the tables's filed on Android Device environment, however, the error prompted in LogCat:

03-23 16:16:45.580: E/Database(657): 失败 1(靠近UNIQUE":语法错误)在准备 'ALTER TABLE game ADD 时出现在 0x2c0240UNIQUE(name);'.

03-23 16:16:45.580: E/Database(657): Failure 1 (near "UNIQUE": syntax error) on 0x2c0240 when preparing 'ALTER TABLE game ADD UNIQUE(name);'.

查看 SQLite 的文档，似乎 SQLite 没有使用这种方式来设置唯一键.有人知道这样做吗?感谢您提前回复！

Checking the SQLite's doc, it seems that SQLite does not use this way for setting a unique key. Does anyboy know to do it ? Thanks for response inadvance !

推荐答案

sqlite 以另一种方式支持改变.您可以尝试以下操作:在游戏(名称)上创建唯一索引unique_name;如果要一次为两列或更多列创建约束:在游戏上创建唯一索引unique_name(name1,name2,mame3);

sqlite support alter in another way. You can try the following: create unique index unique_name on game(name); If you want to create a constraint for two or more columns at one time: create unique index unique_name on game(name1,name2,mame3);

这篇关于SQLite:“ALTER TABLE `game` ADD UNIQUE(`name`)";SQLite 中的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！