Question

It s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.

Closed 11 years ago.

String sqlQueryToCreateUndergraduateDetailsTable = "create table if not exists " + TABLE_NAME_GPA + " ( " + BaseColumns._ID + " integer primary key autoincrement, " +"COLUMN_NAME" + " text not null, " +"COLUMN_SURNAME" + " text not null, " +"COLUMN_DATE_OF_BIRTH"+ "text not null, +"COLUMN_ADDRESS" +"text not null," +"COLUMN_EMAIL" +"text not null," +"COLUMN_PHONE_NUMBER" +"text not null," +"COLUMN_CITY" +"text not null," +"COLUMN_PTYE_PAYMENT" +"text not null," +"COLUMN_SHIPPING_TYPE" +"text not null," +"COLUMN_CARD_NUMBER" + "text not null," +"COLUMN_Password" +"text not null);";

我试图保存到数据库,但它给了我一个错误说....error code = 1, msg = table Customin_ details_able 没有名为“信用卡号码”的栏目

Answer 1

表格或列名称中不能有空格。

更改为 Card_number 或 Cardnumber , 并且应该有效。

<强 > EDIT

看着错误和你说的原话我认为你贴错了SQL

您向我们展示了表格创建 SQL, 但您却说“ 我试图保存 < 坚固> 到 < / 坚固> 数据库 ” 。错误信息似乎显示它正在寻找列, 而不是试图创建列。

我认为你需要查看插入或更新 SQL 方法, 在那里你可能会用手动输入, 而不是使用常数, 意外地放一个空格在那里。

Answer 2

我也不认为你想把常数放进"", 或者你没有常数吗?

它应该看起来像:

String sqlQueryToCreateUndergraduateDetailsTable = "create table if not exists  "
        + TABLE_CREDENTIALS + " ( " + BaseColumns._ID
        + " integer primary key autoincrement, " + COLUMN_NAME
        + " text not null, " + COLUMN_PASSWORD + " text not null);";

Answer 3

您的查询混乱。您需要给列名称及其属性间留出空格。

例如,以下各点:

... +"COLUMN_CARD_NUMBER" + "text not null," + ...

应该是这样:

... +"COLUMN_CARD_NUMBER " + "text not null," + ...

注意列名 后的空白空格

友情链接