android.database.sqlite.SQLiteException: near ": syntax error (code 1): , while compiling: android programing error

You are executing the command:

create_income_table income(    _id INTEGER PRIMARY KEY AUTOINCREMENT,    income_amount TEXT NOT NULL,    income_payer TEXT NOT NULL,    income_date TEXT NOT NULL,    income_category TEXT NOT NULL,    income_payments TEXT NOT NULL);

Replace create_income_table with CREATE TABLE. You need to execute this SQL:

CREATE TABLE income(    _id INTEGER PRIMARY KEY AUTOINCREMENT,    income_amount TEXT NOT NULL,    income_payer TEXT NOT NULL,    income_date TEXT NOT NULL,    income_category TEXT NOT NULL,    income_payments TEXT NOT NULL);

exception is clearly shown in this line

Caused by: android.database.sqlite.SQLiteException: near "create_income_table": syntax error (code 1): , while compiling: create_income_table income(_id INTEGER PRIMARY KEY AUTOINCREMENT, income_amount TEXT NOT NULL, income_payer TEXT NOT NULL, income_date TEXT NOT NULL, income_category TEXT NOT NULL, income_payments TEXT NOT NULL);

use this line to create table

 // TABLE CREATION STATEMENTprivate static final String CREATE_INCOME_TABLE = "create table "        + TABLE_INCOME + "(" + INCOME_ID        + " INTEGER PRIMARY KEY AUTOINCREMENT, "        + INCOME_AMOUNT + " TEXT NOT NULL, "        + INCOME_PAYER + " TEXT NOT NULL, "        + INCOME_DATE + " TEXT NOT NULL, "        + INCOME_CATEGORY + " TEXT NOT NULL, "        + INCOME_PAYMENTS + " TEXT NOT NULL)";

also modify your code for second table create command also