public class MySQLDSL extends DSL
SQLDialect.MYSQL specific DSL.| 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> |
enumType(Class<E> type,
int index)
Get a field based
EnumType by its MySQL-specific index. |
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 |
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, date, date, dateAdd, dateAdd, dateAdd, dateAdd, 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, generateSeries, generateSeries, getDataType, greatest, greatest, groupConcat, 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, isnull, isnull, isnull, isnull, keyword, lag, lag, lag, lag, lastValue, lateral, lead, lead, lead, lead, least, least, left, left, left, left, 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, mid, mid, 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, orderBy, orderBy, orderBy, param, param, param, param, partitionBy, partitionBy, 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, reverse, reverse, right, right, right, right, 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, row, rownum, rowNumber, rowsBetweenCurrentRow, rowsBetweenFollowing, rowsBetweenPreceding, rowsBetweenUnboundedFollowing, rowsBetweenUnboundedPreceding, rowsCurrentRow, rowsFollowing, rowsPreceding, rowsUnboundedFollowing, rowsUnboundedPreceding, 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, space, space, sqrt, sqrt, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, table, table, table, table, table, table, table, table, table, tableByName, tan, tan, tanh, tanh, time, time, timestamp, timestamp, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampDiff, timestampDiff, timestampDiff, timestampDiff, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, trunc, 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, values, varPop, varSamp, year, year, zeropublic static Field<String> decode(String cryptString, String keyString)
DECODE() function
Don't mix this up with the various DSL.decode() methods!
public static Field<String> decode(Field<String> cryptString, Field<String> keyString)
DECODE() function
Don't mix this up with the various DSL.decode() methods!
public static Field<String> encode(String string, String keyString)
ENCODE() functionpublic static Field<String> encode(Field<String> string, Field<String> keyString)
ENCODE() functionpublic static Field<String> aesDecrypt(String cryptString, String keyString)
AES_DECRYPT() functionpublic static Field<String> aesDecrypt(Field<String> cryptString, Field<String> keyString)
AES_DECRYPT() functionpublic static Field<String> aesEncrypt(String string, String keyString)
AES_ENCRYPT() functionpublic static Field<String> aesEncrypt(Field<String> string, Field<String> keyString)
AES_ENCRYPT() functionpublic static Field<String> desDecrypt(String cryptString)
DES_DECRYPT() functionpublic static Field<String> desDecrypt(Field<String> cryptString)
DES_DECRYPT() functionpublic static Field<String> desDecrypt(String cryptString, String keyString)
DES_DECRYPT() functionpublic static Field<String> desDecrypt(Field<String> cryptString, Field<String> keyString)
DES_DECRYPT() functionpublic static Field<String> desEncrypt(String string)
DES_ENCRYPT() functionpublic static Field<String> desEncrypt(Field<String> string)
DES_ENCRYPT() functionpublic static Field<String> desEncrypt(String string, String keyString)
DES_ENCRYPT() functionpublic static Field<String> desEncrypt(Field<String> string, Field<String> keyString)
DES_ENCRYPT() functionpublic static Field<String> compress(String string)
COMPRESS() functionpublic static Field<String> compress(Field<String> string)
COMPRESS() functionpublic static Field<String> uncompress(String string)
UNCOMPRESS() functionpublic static Field<String> uncompress(Field<String> string)
UNCOMPRESS() functionpublic static Field<Integer> uncompressedLength(String string)
UNCOMPRESSED_LENGTH() functionpublic static Field<Integer> uncompressedLength(Field<String> string)
UNCOMPRESSED_LENGTH() functionpublic static Field<String> sha2(String string, int hashLength)
SHA2() functionpublic static Field<String> sha2(Field<String> string, Field<Integer> hashLength)
SHA2() functionpublic static Field<String> password(String string)
PASSWORD() functionpublic static Field<String> password(Field<String> string)
PASSWORD() functionpublic static <E extends Enum<E> & EnumType> E enumType(Class<E> type, int index)
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
Copyright © 2014. All Rights Reserved.