Monday, 4 February 2019

get sql record and count toghether

Query:   Select SQL_CALC_FOUND_ROWS first_name from sh_players.      


           rs.close();
            rs = selectSQL(stmt, "SELECT FOUND_ROWS() as build_count");
            while (rs.next()) {
                build_count = rs.getInt("build_count");
                break;
            }

No comments:

Post a Comment