Sqlite Query execution flow

I have written following sql statement but having problem with its execution flow.I am getting count of record = 12 which is correct .But if i uncomment first two lines means delete all record from allsourcecopy before copying a allsource table to allsourcecopy it return count of record =0 which is incorrect as allsource have 12 no. of records

       // String countQuery1122 =" DELETE FROM allsourcecopy";
       // db1.execSQL(countQuery1122);

        String countQuery112 ="INSERT INTO allsourcecopy SELECT * FROM allsource";
        db1.execSQL(countQuery112);

        String countQuery55="SELECT * FROM allsourcecopy";
        Cursor cursor555= db1.rawQuery(countQuery55, null);
        Integer tt=cursor555.getCount();