public class MySQLDSL extends DSL
SQLDialect.MYSQL specific DSL.| Modifier | Constructor and Description |
|---|---|
protected |
MySQLDSL()
No instances
|
| Modifier and Type | Method and Description |
|---|---|
static Field<byte[]> |
aesDecrypt(byte[] cryptString,
byte[] keyString)
Get the MySQL-specific
AES_DECRYPT() function. |
static <T> Field<T> |
aesDecrypt(Field<T> cryptString,
Field<T> 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<byte[]> |
aesEncrypt(byte[] string,
byte[] keyString)
Get the MySQL-specific
AES_ENCRYPT() function. |
static <T> Field<T> |
aesEncrypt(Field<T> string,
Field<T> 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<byte[]> |
compress(byte[] string)
Get the MySQL-specific
COMPRESS() function. |
static <T> Field<T> |
compress(Field<T> string)
Get the MySQL-specific
COMPRESS() function. |
static Field<String> |
compress(String string)
Get the MySQL-specific
COMPRESS() function. |
static Field<byte[]> |
decode(byte[] cryptString,
byte[] keyString)
Get the MySQL-specific
DECODE() function. |
static <T> Field<T> |
decode(Field<T> cryptString,
Field<T> keyString)
Get the MySQL-specific
DECODE() function. |
static Field<String> |
decode(String cryptString,
String keyString)
Get the MySQL-specific
DECODE() function. |
static Field<byte[]> |
desDecrypt(byte[] cryptString)
Get the MySQL-specific
DES_DECRYPT() function. |
static Field<byte[]> |
desDecrypt(byte[] cryptString,
byte[] keyString)
Get the MySQL-specific
DES_DECRYPT() function. |
static <T> Field<T> |
desDecrypt(Field<T> cryptString)
Get the MySQL-specific
DES_DECRYPT() function. |
static <T> Field<T> |
desDecrypt(Field<T> cryptString,
Field<T> 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<byte[]> |
desEncrypt(byte[] string)
Get the MySQL-specific
DES_ENCRYPT() function. |
static Field<byte[]> |
desEncrypt(byte[] string,
byte[] keyString)
Get the MySQL-specific
DES_ENCRYPT() function. |
static <T> Field<T> |
desEncrypt(Field<T> string)
Get the MySQL-specific
DES_ENCRYPT() function. |
static <T> Field<T> |
desEncrypt(Field<T> string,
Field<T> 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<byte[]> |
encode(byte[] string,
byte[] keyString)
Get the MySQL-specific
ENCODE() function. |
static <T> Field<T> |
encode(Field<T> string,
Field<T> 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<byte[]> |
password(byte[] string)
Get the MySQL-specific
PASSWORD() function. |
static <T> Field<T> |
password(Field<T> string)
Get the MySQL-specific
PASSWORD() function. |
static Field<String> |
password(String string)
Get the MySQL-specific
PASSWORD() function. |
static Field<byte[]> |
sha1(byte[] string)
Get the MySQL-specific
SHA1() function. |
static <T> Field<T> |
sha1(Field<T> string)
Get the MySQL-specific
SHA1() function. |
static Field<String> |
sha1(String string)
Get the MySQL-specific
SHA1() function. |
static Field<byte[]> |
sha2(byte[] string,
int hashLength)
Get the MySQL-specific
SHA2() function. |
static <T> Field<T> |
sha2(Field<T> 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<byte[]> |
uncompress(byte[] string)
Get the MySQL-specific
UNCOMPRESS() function. |
static <T> Field<T> |
uncompress(Field<T> string)
Get the MySQL-specific
UNCOMPRESS() function. |
static Field<String> |
uncompress(String string)
Get the MySQL-specific
UNCOMPRESS() function. |
static Field<Integer> |
uncompressedLength(byte[] string)
Get the MySQL-specific
UNCOMPRESSED_LENGTH() function. |
static <T> Field<Integer> |
uncompressedLength(Field<T> string)
Get the MySQL-specific
UNCOMPRESSED_LENGTH() function. |
static Field<Integer> |
uncompressedLength(String string)
Get the MySQL-specific
UNCOMPRESSED_LENGTH() function. |
static <T> Field<T> |
values(Field<T> values)
Get the MySQL-specific
VALUES() function for use with
INSERT .. |
abs, abs, acos, acos, all, all, all, alterIndex, alterIndex, alterIndexIfExists, alterIndexIfExists, alterSchema, alterSchema, alterSchema, alterSchemaIfExists, alterSchemaIfExists, alterSchemaIfExists, alterSequence, alterSequence, alterSequence, alterSequenceIfExists, alterSequenceIfExists, alterSequenceIfExists, alterTable, alterTable, alterTable, alterTableIfExists, alterTableIfExists, alterTableIfExists, alterView, alterView, alterView, alterViewIfExists, alterViewIfExists, alterViewIfExists, and, and, any, any, any, array, array, array, arrayAgg, 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, boolAnd, boolAnd, boolOr, boolOr, cast, cast, cast, cast, cast, cast, castNull, castNull, castNull, catalog, ceil, ceil, charLength, charLength, check, choose, choose, choose, coalesce, coalesce, coalesce, coerce, coerce, coerce, coerce, coerce, coerce, collect, collect, collectDistinct, collectDistinct, concat, concat, concat, concat, condition, condition, condition, condition, condition, condition, condition, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, constraint, constraint, constraint, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, count, countDistinct, countDistinct, countDistinct, createGlobalTemporaryTable, createGlobalTemporaryTable, createGlobalTemporaryTable, createIndex, createIndex, createIndexIfNotExists, createIndexIfNotExists, createSchema, createSchema, createSchema, createSchemaIfNotExists, createSchemaIfNotExists, createSchemaIfNotExists, createSequence, createSequence, createSequence, createSequenceIfNotExists, createSequenceIfNotExists, createSequenceIfNotExists, createTable, createTable, createTable, createTableIfNotExists, createTableIfNotExists, createTableIfNotExists, createTemporaryTable, createTemporaryTable, createTemporaryTable, createUniqueIndex, createUniqueIndex, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createView, createView, createView, createView, createView, createView, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, cube, cube, cumeDist, cumeDist, currentDate, currentLocalDate, currentLocalDateTime, currentLocalTime, currentOffsetDateTime, currentOffsetTime, currentSchema, currentTime, currentTimestamp, currentUser, date, date, date, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, day, day, day, decode, decode, decode, decode, decode, defaultValue, defaultValue, defaultValue, defaultValue, deg, deg, delete, deleteFrom, denseRank, denseRank, dropIndex, dropIndex, dropIndexIfExists, dropIndexIfExists, dropSchema, dropSchema, dropSchema, dropSchemaIfExists, dropSchemaIfExists, dropSchemaIfExists, dropSequence, dropSequence, dropSequence, dropSequenceIfExists, dropSequenceIfExists, dropSequenceIfExists, dropTable, dropTable, dropTable, dropTableIfExists, dropTableIfExists, dropTableIfExists, dropView, dropView, dropView, dropViewIfExists, dropViewIfExists, dropViewIfExists, dual, e, escape, escape, every, every, exists, exp, exp, extract, extract, extract, falseCondition, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, fieldByName, fieldByName, fieldByName, firstValue, floor, floor, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, function, function, function, function, generateSeries, generateSeries, generateSeries, generateSeries, getDataType, greatest, greatest, groupConcat, groupConcat, groupConcatDistinct, grouping, groupingId, groupingSets, groupingSets, groupingSets, hour, hour, hour, ifnull, ifnull, ifnull, ifnull, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, 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, link, link, link, list, list, listAgg, listAgg, ln, ln, localDate, localDate, localDate, localDateTime, localDateTime, localDateTime, localTime, localTime, localTime, 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, minute, mode, month, month, month, name, name, not, not, not, notExists, nthValue, nthValue, ntile, nullif, nullif, nullif, nullif, nullSafe, nullSafe, nullSafe, nullSafeDataType, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, offsetDateTime, offsetDateTime, offsetDateTime, offsetTime, offsetTime, offsetTime, one, or, or, orderBy, orderBy, orderBy, param, param, param, param, param, param, param, param, param, partitionBy, partitionBy, percentileCont, percentileCont, percentileDisc, percentileDisc, percentRank, percentRank, pi, position, position, position, position, position, position, position, position, position, position, position, position, power, power, power, power, primaryKey, primaryKey, prior, queries, queries, query, query, query, query, queryPart, queryPart, queryPart, rad, rad, rand, rangeBetweenCurrentRow, rangeBetweenFollowing, rangeBetweenPreceding, rangeBetweenUnboundedFollowing, rangeBetweenUnboundedPreceding, rangeCurrentRow, rangeFollowing, rangePreceding, rangeUnboundedFollowing, rangeUnboundedPreceding, rank, rank, ratioToReport, ratioToReport, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, repeat, repeat, repeat, repeat, replace, replace, replace, replace, resultQuery, resultQuery, resultQuery, resultQuery, reverse, reverse, right, right, right, right, rollup, 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, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rownum, rowNumber, rowsBetweenCurrentRow, rowsBetweenFollowing, rowsBetweenPreceding, rowsBetweenUnboundedFollowing, rowsBetweenUnboundedPreceding, rowsCurrentRow, rowsFollowing, rowsFrom, rowsPreceding, rowsUnboundedFollowing, rowsUnboundedPreceding, rpad, rpad, rpad, rpad, rpad, rtrim, rtrim, schema, schemaByName, second, 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, sequence, sequence, sequence, sequence, sequence, sequence, sequenceByName, sequenceByName, sequenceByName, shl, shl, shl, shl, shr, shr, shr, shr, sign, sign, sin, sin, sinh, sinh, space, space, sql, sql, sql, sqrt, sqrt, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, table, table, table, table, table, table, table, table, table, table, table, table, table, tableByName, tan, tan, tanh, tanh, time, time, time, timestamp, timestamp, timestamp, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampDiff, timestampDiff, timestampDiff, timestampDiff, toDate, toDate, toDate, toDate, toLocalDate, toLocalDate, toLocalDate, toLocalDate, toLocalDateTime, toLocalDateTime, toLocalDateTime, toLocalDateTime, toTimestamp, toTimestamp, toTimestamp, toTimestamp, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, truncate, truncate, two, unique, unique, unnest, unnest, unnest, unnest, update, upper, upper, using, using, using, using, using, using, using, using, using, using, using, using, using, using, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, 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, when, when, when, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, year, year, year, zero@Support(value=MYSQL) public static Field<String> decode(String cryptString, String keyString)
DECODE() function.
Don't mix this up with the various DSL.decode() methods!
@Support(value=MYSQL) public static Field<byte[]> decode(byte[] cryptString, byte[] keyString)
DECODE() function.
Don't mix this up with the various DSL.decode() methods!
@Support(value=MYSQL) public static <T> Field<T> decode(Field<T> cryptString, Field<T> keyString)
DECODE() function.
Don't mix this up with the various DSL.decode() methods!
@Support(value=MYSQL) public static Field<String> encode(String string, String keyString)
ENCODE() function.@Support(value=MYSQL) public static Field<byte[]> encode(byte[] string, byte[] keyString)
ENCODE() function.@Support(value=MYSQL) public static <T> Field<T> encode(Field<T> string, Field<T> keyString)
ENCODE() function.@Support(value=MYSQL) public static Field<String> aesDecrypt(String cryptString, String keyString)
AES_DECRYPT() function.@Support(value=MYSQL) public static Field<byte[]> aesDecrypt(byte[] cryptString, byte[] keyString)
AES_DECRYPT() function.@Support(value=MYSQL) public static <T> Field<T> aesDecrypt(Field<T> cryptString, Field<T> keyString)
AES_DECRYPT() function.@Support(value=MYSQL) public static Field<String> aesEncrypt(String string, String keyString)
AES_ENCRYPT() function.@Support(value=MYSQL) public static Field<byte[]> aesEncrypt(byte[] string, byte[] keyString)
AES_ENCRYPT() function.@Support(value=MYSQL) public static <T> Field<T> aesEncrypt(Field<T> string, Field<T> keyString)
AES_ENCRYPT() function.@Support(value=MYSQL) public static Field<String> desDecrypt(String cryptString)
DES_DECRYPT() function.@Support(value=MYSQL) public static Field<byte[]> desDecrypt(byte[] cryptString)
DES_DECRYPT() function.@Support(value=MYSQL) public static <T> Field<T> desDecrypt(Field<T> cryptString)
DES_DECRYPT() function.@Support(value=MYSQL) public static Field<String> desDecrypt(String cryptString, String keyString)
DES_DECRYPT() function.@Support(value=MYSQL) public static Field<byte[]> desDecrypt(byte[] cryptString, byte[] keyString)
DES_DECRYPT() function.@Support(value=MYSQL) public static <T> Field<T> desDecrypt(Field<T> cryptString, Field<T> keyString)
DES_DECRYPT() function.@Support(value=MYSQL) public static Field<String> desEncrypt(String string)
DES_ENCRYPT() function.@Support(value=MYSQL) public static Field<byte[]> desEncrypt(byte[] string)
DES_ENCRYPT() function.@Support(value=MYSQL) public static <T> Field<T> desEncrypt(Field<T> string)
DES_ENCRYPT() function.@Support(value=MYSQL) public static Field<String> desEncrypt(String string, String keyString)
DES_ENCRYPT() function.@Support(value=MYSQL) public static Field<byte[]> desEncrypt(byte[] string, byte[] keyString)
DES_ENCRYPT() function.@Support(value=MYSQL) public static <T> Field<T> desEncrypt(Field<T> string, Field<T> keyString)
DES_ENCRYPT() function.@Support(value=MYSQL) public static Field<String> compress(String string)
COMPRESS() function.@Support(value=MYSQL) public static Field<byte[]> compress(byte[] string)
COMPRESS() function.@Support(value=MYSQL) public static <T> Field<T> compress(Field<T> string)
COMPRESS() function.@Support(value=MYSQL) public static Field<String> uncompress(String string)
UNCOMPRESS() function.@Support(value=MYSQL) public static Field<byte[]> uncompress(byte[] string)
UNCOMPRESS() function.@Support(value=MYSQL) public static <T> Field<T> uncompress(Field<T> string)
UNCOMPRESS() function.@Support(value=MYSQL) public static Field<Integer> uncompressedLength(String string)
UNCOMPRESSED_LENGTH() function.@Support(value=MYSQL) public static Field<Integer> uncompressedLength(byte[] string)
UNCOMPRESSED_LENGTH() function.@Support(value=MYSQL) public static <T> Field<Integer> uncompressedLength(Field<T> string)
UNCOMPRESSED_LENGTH() function.@Support(value=MYSQL) public static Field<String> sha1(String string)
SHA1() function.@Support(value=MYSQL) public static Field<byte[]> sha1(byte[] string)
SHA1() function.@Support(value=MYSQL) public static <T> Field<T> sha1(Field<T> string)
SHA1() function.@Support(value=MYSQL) public static Field<String> sha2(String string, int hashLength)
SHA2() function.@Support(value=MYSQL) public static Field<byte[]> sha2(byte[] string, int hashLength)
SHA2() function.@Support(value=MYSQL) public static <T> Field<T> sha2(Field<T> string, Field<Integer> hashLength)
SHA2() function.@Support(value=MYSQL) public static Field<String> password(String string)
PASSWORD() function.@Support(value=MYSQL) public static Field<byte[]> password(byte[] string)
PASSWORD() function.@Support(value=MYSQL) public static <T> Field<T> password(Field<T> string)
PASSWORD() function.@Support(value=MYSQL) public static <T> Field<T> values(Field<T> values)
VALUES() function for use with
INSERT .. ON DUPLICATE KEY UPDATE statements.public 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 © 2017. All Rights Reserved.