org.jooq.util.mysql

Class MySQLDSL

java.lang.Object

org.jooq.impl.DSL

org.jooq.util.mysql.MySQLDSL

public class MySQLDSL
extends DSL

The SQLDialect.MYSQL specific DSL.

Author:

Lukas Eder

Method Summary

Methods

Modifier and Type	Method and Description
static Field<String>	aesDecrypt(Field<String> cryptString, Field<String> keyString) Get the MySQL-specific AES_DECRYPT() function
static Field<String>	aesDecrypt(String cryptString, String keyString) Get the MySQL-specific AES_DECRYPT() function
static Field<String>	aesEncrypt(Field<String> string, Field<String> keyString) Get the MySQL-specific AES_ENCRYPT() function
static Field<String>	aesEncrypt(String string, String keyString) Get the MySQL-specific AES_ENCRYPT() function
static Field<String>	compress(Field<String> string) Get the MySQL-specific COMPRESS() function
static Field<String>	compress(String string) Get the MySQL-specific COMPRESS() function
static Field<String>	decode(Field<String> cryptString, Field<String> keyString) Get the MySQL-specific DECODE() function Don't mix this up with the various DSL.decode() methods!
static Field<String>	decode(String cryptString, String keyString) Get the MySQL-specific DECODE() function Don't mix this up with the various DSL.decode() methods!
static Field<String>	desDecrypt(Field<String> cryptString) Get the MySQL-specific DES_DECRYPT() function
static Field<String>	desDecrypt(Field<String> cryptString, Field<String> keyString) Get the MySQL-specific DES_DECRYPT() function
static Field<String>	desDecrypt(String cryptString) Get the MySQL-specific DES_DECRYPT() function
static Field<String>	desDecrypt(String cryptString, String keyString) Get the MySQL-specific DES_DECRYPT() function
static Field<String>	desEncrypt(Field<String> string) Get the MySQL-specific DES_ENCRYPT() function
static Field<String>	desEncrypt(Field<String> string, Field<String> keyString) Get the MySQL-specific DES_ENCRYPT() function
static Field<String>	desEncrypt(String string) Get the MySQL-specific DES_ENCRYPT() function
static Field<String>	desEncrypt(String string, String keyString) Get the MySQL-specific DES_ENCRYPT() function
static Field<String>	encode(Field<String> string, Field<String> keyString) Get the MySQL-specific ENCODE() function
static Field<String>	encode(String string, String keyString) Get the MySQL-specific ENCODE() function
static <E extends Enum<E> & EnumType> E	enumType(Class<E> type, int index) Get a field based EnumType by its MySQL-specific index If your MySQL enum type contains these three values: A, B, C , then this will be the mapping of indexes to values: Enum literal as in Enum.name() Enum ordinal as in Enum.ordinal() MySQL index null-0A01B12C23 See dev.mysql.com/doc/ refman/5.5/en/enum.html for more details about MySQL enum types static Field<String> password(Field<String> string) Get the MySQL-specific PASSWORD() function static Field<String> password(String string) Get the MySQL-specific PASSWORD() function static Field<String> sha1(Field<String> string) Get the MySQL-specific SHA1() function static Field<String> sha1(String string) Get the MySQL-specific SHA1() function static Field<String> sha2(Field<String> string, Field<Integer> hashLength) Get the MySQL-specific SHA2() function static Field<String> sha2(String string, int hashLength) Get the MySQL-specific SHA2() function static Field<String> uncompress(Field<String> string) Get the MySQL-specific UNCOMPRESS() function static Field<String> uncompress(String string) Get the MySQL-specific UNCOMPRESS() function static Field<Integer> uncompressedLength(Field<String> string) Get the MySQL-specific UNCOMPRESSED_LENGTH() function static Field<Integer> uncompressedLength(String string) Get the MySQL-specific UNCOMPRESSED_LENGTH() function Methods inherited from class org.jooq.impl.DSL abs, abs, acos, acos, all, all, all, any, any, any, ascii, ascii, asin, asin, atan, atan, atan2, atan2, atan2, atan2, avg, avgDistinct, bitAnd, bitAnd, bitAnd, bitAnd, bitCount, bitCount, bitLength, bitLength, bitNand, bitNand, bitNand, bitNand, bitNor, bitNor, bitNor, bitNor, bitNot, bitNot, bitOr, bitOr, bitOr, bitOr, bitXNor, bitXNor, bitXNor, bitXNor, bitXor, bitXor, bitXor, bitXor, cast, cast, cast, cast, cast, cast, castNull, castNull, castNull, ceil, ceil, charLength, charLength, coalesce, coalesce, coerce, coerce, coerce, concat, concat, condition, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, countDistinct, countDistinct, cube, cumeDist, currentDate, currentTime, currentTimestamp, currentUser, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, day, day, decode, decode, decode, decode, decode, deg, deg, delete, denseRank, dual, e, escape, escape, exists, exp, exp, extract, extract, falseCondition, field, field, field, field, field, field, field, field, field, field, fieldByName, fieldByName, fieldByName, firstValue, floor, floor, function, function, function, function, generateSeries, generateSeries, getDataType, greatest, greatest, groupConcat, groupConcatDistinct, grouping, groupingId, groupingSets, groupingSets, groupingSets, hour, hour, inline, inline, inline, inline, inline, inline, inline, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, keyword, lag, lag, lag, lag, lastValue, lead, lead, lead, lead, least, least, length, length, level, listAgg, listAgg, ln, ln, log, log, lower, lower, lpad, lpad, lpad, lpad, lpad, ltrim, ltrim, max, maxDistinct, md5, md5, median, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, min, minDistinct, minute, minute, month, month, name, not, notExists, ntile, nullif, nullif, nullif, nullif, nullSafe, nullSafe, nullSafeDataType, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, one, param, param, param, param, percentRank, pi, position, position, position, position, power, power, power, power, prior, queryPart, queryPart, queryPart, rad, rad, rand, rank, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, repeat, repeat, repeat, repeat, replace, replace, replace, replace, rollup, round, round, round, round, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, rownum, rowNumber, rpad, rpad, rpad, rpad, rpad, rtrim, rtrim, schemaByName, second, second, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, selectCount, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectFrom, selectOne, selectZero, shl, shl, shl, shl, shr, shr, shr, shr, sign, sign, sin, sin, sinh, sinh, sqrt, sqrt, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, table, table, table, table, table, table, table, table, tableByName, tan, tan, tanh, tanh, timestampAdd, timestampAdd, timestampDiff, timestampDiff, timestampDiff, timestampDiff, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, truncate, two, unnest, unnest, unnest, unnest, update, upper, upper, using, using, using, using, using, using, using, using, using, using, using, val, val, val, val, value, value, value, value, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, varPop, varSamp, year, year, zero Methods inherited from class java.lang.Object clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait Method Detail decode public static Field<String> decode(String cryptString, String keyString) Get the MySQL-specific DECODE() function Don't mix this up with the various DSL.decode() methods! decode public static Field<String> decode(Field<String> cryptString, Field<String> keyString) Get the MySQL-specific DECODE() function Don't mix this up with the various DSL.decode() methods! encode public static Field<String> encode(String string, String keyString) Get the MySQL-specific ENCODE() function encode public static Field<String> encode(Field<String> string, Field<String> keyString) Get the MySQL-specific ENCODE() function aesDecrypt public static Field<String> aesDecrypt(String cryptString, String keyString) Get the MySQL-specific AES_DECRYPT() function aesDecrypt public static Field<String> aesDecrypt(Field<String> cryptString, Field<String> keyString) Get the MySQL-specific AES_DECRYPT() function aesEncrypt public static Field<String> aesEncrypt(String string, String keyString) Get the MySQL-specific AES_ENCRYPT() function aesEncrypt public static Field<String> aesEncrypt(Field<String> string, Field<String> keyString) Get the MySQL-specific AES_ENCRYPT() function desDecrypt public static Field<String> desDecrypt(String cryptString) Get the MySQL-specific DES_DECRYPT() function desDecrypt public static Field<String> desDecrypt(Field<String> cryptString) Get the MySQL-specific DES_DECRYPT() function desDecrypt public static Field<String> desDecrypt(String cryptString, String keyString) Get the MySQL-specific DES_DECRYPT() function desDecrypt public static Field<String> desDecrypt(Field<String> cryptString, Field<String> keyString) Get the MySQL-specific DES_DECRYPT() function desEncrypt public static Field<String> desEncrypt(String string) Get the MySQL-specific DES_ENCRYPT() function desEncrypt public static Field<String> desEncrypt(Field<String> string) Get the MySQL-specific DES_ENCRYPT() function desEncrypt public static Field<String> desEncrypt(String string, String keyString) Get the MySQL-specific DES_ENCRYPT() function desEncrypt public static Field<String> desEncrypt(Field<String> string, Field<String> keyString) Get the MySQL-specific DES_ENCRYPT() function compress public static Field<String> compress(String string) Get the MySQL-specific COMPRESS() function compress public static Field<String> compress(Field<String> string) Get the MySQL-specific COMPRESS() function uncompress public static Field<String> uncompress(String string) Get the MySQL-specific UNCOMPRESS() function uncompress public static Field<String> uncompress(Field<String> string) Get the MySQL-specific UNCOMPRESS() function uncompressedLength public static Field<Integer> uncompressedLength(String string) Get the MySQL-specific UNCOMPRESSED_LENGTH() function uncompressedLength public static Field<Integer> uncompressedLength(Field<String> string) Get the MySQL-specific UNCOMPRESSED_LENGTH() function sha1 public static Field<String> sha1(String string) Get the MySQL-specific SHA1() function sha1 public static Field<String> sha1(Field<String> string) Get the MySQL-specific SHA1() function sha2 public static Field<String> sha2(String string, int hashLength) Get the MySQL-specific SHA2() function sha2 public static Field<String> sha2(Field<String> string, Field<Integer> hashLength) Get the MySQL-specific SHA2() function password public static Field<String> password(String string) Get the MySQL-specific PASSWORD() function password public static Field<String> password(Field<String> string) Get the MySQL-specific PASSWORD() function enumType public static <E extends Enum<E> & EnumType> E enumType(Class<E> type, int index) Get a field based EnumType by its MySQL-specific index If your MySQL enum type contains these three values: A, B, C , then this will be the mapping of indexes to values: Enum literal as in Enum.name() Enum ordinal as in Enum.ordinal() MySQL index null - 0 A 0 1 B 1 2 C 2 3 See dev.mysql.com/doc/ refman/5.5/en/enum.html for more details about MySQL enum types Overview Package Class Use Deprecated Index Help Prev Class Next Class Frames No Frames All Classes Summary: Nested | Field | Constr | Method Detail: Field | Constr | Method Copyright © 2013. All Rights Reserved.