在android中创建表时出现语法错误-syntaxerrorincreatingatableinandroid

5  

I would guess that "Transaction" is a key word that you are not allowed to use. Try changing the name to something else.

我猜“交易”是一个不允许使用的关键词。尝试将名称更改为其他名称。

1  

Care must be taken when using SQLite keywords as identifier names.As a general rule of thumb you should try to avoid using any keywords from the SQL language as identifiers, although if you really want to do so, they can be used providing they are enclosed in square brackets. For instance the following statement will work just fine, but this should not be mimicked on a real database sqlite> CREATE TABLE [TABLE] ( ...> [SELECT], ...> [INTEGER] INTEGER, ...> [FROM], ...> [TABLE] ...> );

使用SQLite关键字作为标识符名称时必须小心。作为一般经验法则，您应该尽量避免使用SQL语言中的任何关键字作为标识符，尽管如果您真的想这样做，可以使用它们，前提是它们是封闭的在方括号内。例如，以下语句可以正常工作，但不应在真实数据库上模仿sqlite> CREATE TABLE [TABLE]（...> [SELECT]，...> [INTEGER] INTEGER，...> [ FROM]，...> [TABLE] ...>）;

here is a link for sqlite keywords

这是sqlite关键字的链接

http://www.sqlite.org/lang_keywords.html

http://www.sqlite.org/lang_keywords.html

and here you can find naming conventions for databses

在这里你可以找到数据库的命名约定

http://www.pearsonhighered.com/assets/hip/us/hip_us_pearsonhighered/samplechapter/067232685X.pdf

http://www.pearsonhighered.com/assets/hip/us/hip_us_pearsonhighered/samplechapter/067232685X.pdf