Create table syntax error SQLite

Question

I get a syntax error when I create a four rows table in my SQLite and I don't know why. This is my code.

 private static final String TABLE_PRIMERO = "jugadors";

// Jugadors Table Columns names
private static final String KEY_ID = "id";
private static final String KEY_NAME = "name";
private static final String KEY_ALTURA = "altura";
private static final String KEY_PARTIDO = "partido";

int oldVersion=1;

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

// Creating Tables
@Override
public void onCreate(SQLiteDatabase db) {

    String CREATE_JUGADORS_TABLE1 = "CREATE TABLE_PRIMERO " + TABLE_PRIMERO + "("
            + KEY_ID + " INTEGER PRIMARY KEY,"
            + KEY_NAME + " TEXT,"
            + KEY_ALTURA + " TEXT,"
            + KEY_PARTIDO + " TEXT"
            + ")";
    db.execSQL(CREATE_JUGADORS_TABLE1);


}

//Upgrading database
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    // Drop older table if existed
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_PRIMERO);

    // Create tables again
    onCreate(db);
}

I don't know what i'm doing wrong.

Thanks in advance.

laalto · Accepted Answer · 2014-02-20 12:06:55Z

2

String CREATE_JUGADORS_TABLE1 = "CREATE TABLE_PRIMERO " + TABLE_PRIMERO + "("
        + KEY_ID + " INTEGER PRIMARY KEY,"
        + KEY_NAME + " TEXT,"
        + KEY_ALTURA + " TEXT,"
        + KEY_PARTIDO + " TEXT"
        + ")";

This should be something like

String CREATE_JUGADORS_TABLE1 = "CREATE TABLE " + TABLE_PRIMERO + "("
        + KEY_ID + " INTEGER PRIMARY KEY,"
        + KEY_NAME + " TEXT,"
        + KEY_ALTURA + " TEXT,"
        + KEY_PARTIDO + " TEXT"
        + ")";

The TABLE is a keyword with a specific meaning.

answered Feb 20, 2014 at 12:06

laalto

153k68 gold badges293 silver badges306 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create table syntax error SQLite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related