Uses of Class
com.querydsl.sql.mysql.MySQLQuery

Packages that use MySQLQuery

Package	Description
com.querydsl.sql.mysql	MySQL support

Uses of MySQLQuery in com.querydsl.sql.mysql

Methods in com.querydsl.sql.mysql that return MySQLQuery

Modifier and Type	Method and Description
MySQLQuery<T>	MySQLQuery.bigResult() For SQL_BIG_RESULT, MySQL directly uses disk-based temporary tables if needed, and prefers sorting to using a temporary table with a key on the GROUP BY elements.
MySQLQuery<T>	MySQLQuery.bufferResult() SQL_BUFFER_RESULT forces the result to be put into a temporary table.
MySQLQuery<T>	MySQLQuery.cache() SQL_CACHE tells MySQL to store the result in the query cache if it is cacheable and the value of the query_cache_type system variable is 2 or DEMAND.
MySQLQuery<T>	MySQLQuery.calcFoundRows() SQL_CALC_FOUND_ROWS tells MySQL to calculate how many rows there would be in the result set, disregarding any LIMIT clause.
MySQLQuery<T>	MySQLQuery.clone(Connection conn)
MySQLQuery<T>	MySQLQuery.forceIndex(String... indexes) You can use FORCE INDEX, which acts like USE INDEX (index_list) but with the addition that a table scan is assumed to be very expensive.
MySQLQuery<T>	MySQLQuery.highPriority() HIGH_PRIORITY gives the SELECT higher priority than a statement that updates a table.
MySQLQuery<T>	MySQLQuery.ignoreIndex(String... indexes) The alternative syntax IGNORE INDEX (index_list) can be used to tell MySQL to not use some particular index or indexes.
MySQLQuery<T>	MySQLQuery.into(String var) SELECT ...
MySQLQuery<T>	MySQLQuery.intoDumpfile(File file) SELECT ...
MySQLQuery<T>	MySQLQuery.intoOutfile(File file) SELECT ...
MySQLQuery<T>	MySQLQuery.lockInShareMode() Using LOCK IN SHARE MODE sets a shared lock that permits other transactions to read the examined rows but not to update or delete them.
MySQLQuery<T>	MySQLQuery.noCache() With SQL_NO_CACHE, the server does not use the query cache.
MySQLQuery<?>	MySQLQueryFactory.query()
MySQLQuery<Tuple>	MySQLQueryFactory.select(Expression<?>... exprs)
MySQLQuery<Tuple>	MySQLQuery.select(Expression<?>... exprs)
<T> MySQLQuery<T>	MySQLQueryFactory.select(Expression<T> expr)
<U> MySQLQuery<U>	MySQLQuery.select(Expression<U> expr)
MySQLQuery<Tuple>	MySQLQueryFactory.selectDistinct(Expression<?>... exprs)
<T> MySQLQuery<T>	MySQLQueryFactory.selectDistinct(Expression<T> expr)
<T> MySQLQuery<T>	MySQLQueryFactory.selectFrom(RelationalPath<T> expr)
MySQLQuery<Integer>	MySQLQueryFactory.selectOne()
MySQLQuery<Integer>	MySQLQueryFactory.selectZero()
MySQLQuery<T>	MySQLQuery.smallResult() For SQL_SMALL_RESULT, MySQL uses fast temporary tables to store the resulting table instead of using sorting.
MySQLQuery<T>	MySQLQuery.straightJoin() STRAIGHT_JOIN forces the optimizer to join the tables in the order in which they are listed in the FROM clause.
MySQLQuery<T>	MySQLQuery.useIndex(String... indexes) By specifying USE INDEX (index_list), you can tell MySQL to use only one of the named indexes to find rows in the table.
MySQLQuery<T>	MySQLQuery.withRollup() The GROUP BY clause permits a WITH ROLLUP modifier that causes extra rows to be added to the summary output.