java我想创建一个表，但它给了我一个错误

Question

此代码用于创建一个新表

 import 安卓.database.sqlite.SQLiteOpenHelper;
import 安卓.content.Context;
import 安卓.database.sqlite.SQLiteDatabase;
import 安卓.util.Log;


public class MySQLHelper extends SQLiteOpenHelper {

    public static final String DATABASE_NAME = "verlaufAufgaben.db";
    public static final int DATABASE_VERSION = 1;

创建表格

    private static final String TABLE_CREATE_VERLAUF = ""
            +"create table VERLAUF ("
            +" ID integer primary key, "
            +" Zahl1 int,) ";


    public MySQLHelper(Context context) 
    {   
        super (context, DATABASE_NAME, null, DATABASE_VERSION);
    }

创建SQLITE数据库

    @Override
    public void onCreate(SQLiteDatabase database)
    {
        database.execSQL(TABLE_CREATE_VERLAUF);
    }

升级数据库

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
    {
        Log.w(MySQLHelper.class.getName(),
                "Upgrading database from version " + oldVersion + "to "
                + newVersion + ", which all destroy all old data");
        db.execSQL("DROP TABLE IF EXISTS SCANITEM");
        onCreate(db);
    }

}

这段代码出了什么问题，它向我显示了一个错误，因为这个表

Answer 1

你让表格create DDL以逗号结尾。。。把它拿走

private static final String TABLE_CREATE_VERLAUF = ""
        +"create table VERLAUF ("
        +" ID integer primary key, "
        +" Zahl1 int) ";