如何使用sqlite-android将2行合并为1？

implementation 'com.readystatesoftware.sqlite-android:sqlite-android:2.0.1'

SQLiteOpenHelper dbHelper = new SQLiteOpenHelper(context, "database.db", null, 1) {
    @Override
    public void onCreate(SQLiteDatabase db) {
        // 创建数据库表格
        db.execSQL("CREATE TABLE IF NOT EXISTS my_table (id INTEGER PRIMARY KEY, name TEXT)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 数据库升级操作
    }
};

SQLiteDatabase db = dbHelper.getWritableDatabase();

String query = "SELECT * FROM my_table WHERE id = 1 OR id = 2";
Cursor cursor = db.rawQuery(query, null);

if (cursor.moveToFirst()) {
    String name1 = cursor.getString(cursor.getColumnIndex("name"));
    cursor.moveToNext();
    String name2 = cursor.getString(cursor.getColumnIndex("name"));

    // 合并两行数据为一行
    String mergedName = name1 + " " + name2;

    // 更新数据库中的数据
    ContentValues values = new ContentValues();
    values.put("name", mergedName);
    db.update("my_table", values, "id = 1", null);

    // 删除第二行数据
    db.delete("my_table", "id = 2", null);
}

cursor.close();