- java.lang.Object
-
- org.jooq.impl.DSL
-
- org.jooq.util.mysql.MySQLDSL
-
public class MySQLDSL extends DSL
TheSQLDialect.MYSQL
specific DSL.- Author:
- Lukas Eder
-
-
Constructor Summary
Constructors Modifier Constructor Description protected
MySQLDSL()
No instances
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static Field<byte[]>
aesDecrypt(byte[] cryptString, byte[] keyString)
Get the MySQL-specificAES_DECRYPT()
function.static Field<String>
aesDecrypt(String cryptString, String keyString)
Get the MySQL-specificAES_DECRYPT()
function.static <T> Field<T>
aesDecrypt(Field<T> cryptString, Field<T> keyString)
Get the MySQL-specificAES_DECRYPT()
function.static Field<byte[]>
aesEncrypt(byte[] string, byte[] keyString)
Get the MySQL-specificAES_ENCRYPT()
function.static Field<String>
aesEncrypt(String string, String keyString)
Get the MySQL-specificAES_ENCRYPT()
function.static <T> Field<T>
aesEncrypt(Field<T> string, Field<T> keyString)
Get the MySQL-specificAES_ENCRYPT()
function.static Field<byte[]>
compress(byte[] string)
Get the MySQL-specificCOMPRESS()
function.static Field<String>
compress(String string)
Get the MySQL-specificCOMPRESS()
function.static <T> Field<T>
compress(Field<T> string)
Get the MySQL-specificCOMPRESS()
function.static Field<byte[]>
decode(byte[] cryptString, byte[] keyString)
Get the MySQL-specificDECODE()
function.static Field<String>
decode(String cryptString, String keyString)
Get the MySQL-specificDECODE()
function.static <T> Field<T>
decode(Field<T> cryptString, Field<T> keyString)
Get the MySQL-specificDECODE()
function.static Field<byte[]>
desDecrypt(byte[] cryptString)
Get the MySQL-specificDES_DECRYPT()
function.static Field<byte[]>
desDecrypt(byte[] cryptString, byte[] keyString)
Get the MySQL-specificDES_DECRYPT()
function.static Field<String>
desDecrypt(String cryptString)
Get the MySQL-specificDES_DECRYPT()
function.static Field<String>
desDecrypt(String cryptString, String keyString)
Get the MySQL-specificDES_DECRYPT()
function.static <T> Field<T>
desDecrypt(Field<T> cryptString)
Get the MySQL-specificDES_DECRYPT()
function.static <T> Field<T>
desDecrypt(Field<T> cryptString, Field<T> keyString)
Get the MySQL-specificDES_DECRYPT()
function.static Field<byte[]>
desEncrypt(byte[] string)
Get the MySQL-specificDES_ENCRYPT()
function.static Field<byte[]>
desEncrypt(byte[] string, byte[] keyString)
Get the MySQL-specificDES_ENCRYPT()
function.static Field<String>
desEncrypt(String string)
Get the MySQL-specificDES_ENCRYPT()
function.static Field<String>
desEncrypt(String string, String keyString)
Get the MySQL-specificDES_ENCRYPT()
function.static <T> Field<T>
desEncrypt(Field<T> string)
Get the MySQL-specificDES_ENCRYPT()
function.static <T> Field<T>
desEncrypt(Field<T> string, Field<T> keyString)
Get the MySQL-specificDES_ENCRYPT()
function.static Field<byte[]>
encode(byte[] string, byte[] keyString)
Get the MySQL-specificENCODE()
function.static Field<String>
encode(String string, String keyString)
Get the MySQL-specificENCODE()
function.static <T> Field<T>
encode(Field<T> string, Field<T> keyString)
Get the MySQL-specificENCODE()
function.static <E extends Enum<E> & EnumType>
EenumType(Class<E> type, int index)
Get a field basedEnumType
by its MySQL-specific index.static Field<byte[]>
password(byte[] string)
Get the MySQL-specificPASSWORD()
function.static Field<String>
password(String string)
Get the MySQL-specificPASSWORD()
function.static <T> Field<T>
password(Field<T> string)
Get the MySQL-specificPASSWORD()
function.static Field<byte[]>
sha1(byte[] string)
Get the MySQL-specificSHA1()
function.static Field<String>
sha1(String string)
Get the MySQL-specificSHA1()
function.static <T> Field<T>
sha1(Field<T> string)
Get the MySQL-specificSHA1()
function.static Field<byte[]>
sha2(byte[] string, int hashLength)
Get the MySQL-specificSHA2()
function.static Field<String>
sha2(String string, int hashLength)
Get the MySQL-specificSHA2()
function.static <T> Field<T>
sha2(Field<T> string, Field<Integer> hashLength)
Get the MySQL-specificSHA2()
function.static Field<byte[]>
uncompress(byte[] string)
Get the MySQL-specificUNCOMPRESS()
function.static Field<String>
uncompress(String string)
Get the MySQL-specificUNCOMPRESS()
function.static <T> Field<T>
uncompress(Field<T> string)
Get the MySQL-specificUNCOMPRESS()
function.static Field<Integer>
uncompressedLength(byte[] string)
Get the MySQL-specificUNCOMPRESSED_LENGTH()
function.static Field<Integer>
uncompressedLength(String string)
Get the MySQL-specificUNCOMPRESSED_LENGTH()
function.static <T> Field<Integer>
uncompressedLength(Field<T> string)
Get the MySQL-specificUNCOMPRESSED_LENGTH()
function.static <T> Field<T>
values(Field<T> values)
Get the MySQL-specificVALUES()
function for use withINSERT ..
-
Methods inherited from class org.jooq.impl.DSL
abs, abs, acos, acos, all, all, all, all, alterIndex, alterIndex, alterIndex, alterIndexIfExists, alterIndexIfExists, alterIndexIfExists, alterSchema, alterSchema, alterSchema, alterSchemaIfExists, alterSchemaIfExists, alterSchemaIfExists, alterSequence, alterSequence, alterSequence, alterSequenceIfExists, alterSequenceIfExists, alterSequenceIfExists, alterTable, alterTable, alterTable, alterTableIfExists, alterTableIfExists, alterTableIfExists, alterType, alterType, alterView, alterView, alterView, alterViewIfExists, alterViewIfExists, alterViewIfExists, and, and, and, any, any, any, any, array, array, array, arrayAgg, arrayAggDistinct, ascii, ascii, asin, asin, asterisk, atan, atan, atan2, atan2, atan2, atan2, avg, avgDistinct, begin, begin, 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, case_, case_, case_, cast, cast, cast, cast, cast, cast, castNull, castNull, castNull, catalog, ceil, ceil, century, century, century, characterSet, characterSet, charLength, charLength, check, choose, choose, choose, choose, choose, choose, choose, coalesce, coalesce, coalesce, coerce, coerce, coerce, coerce, coerce, coerce, collation, collation, collect, collect, collectDistinct, collectDistinct, comment, commentOnColumn, commentOnColumn, commentOnTable, commentOnTable, commentOnTable, commentOnView, commentOnView, commentOnView, concat, concat, concat, concat, condition, condition, condition, condition, condition, condition, condition, condition, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, constraint, constraint, constraint, continue_, continue_, continueWhen, convert, convert, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, count, count, countDistinct, countDistinct, countDistinct, countDistinct, createGlobalTemporaryTable, createGlobalTemporaryTable, createGlobalTemporaryTable, createIndex, createIndex, createIndex, createIndex, createIndexIfNotExists, createIndexIfNotExists, createIndexIfNotExists, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createSchema, createSchema, createSchema, createSchemaIfNotExists, createSchemaIfNotExists, createSchemaIfNotExists, createSequence, createSequence, createSequence, createSequenceIfNotExists, createSequenceIfNotExists, createSequenceIfNotExists, createTable, createTable, createTable, createTableIfNotExists, createTableIfNotExists, createTableIfNotExists, createTemporaryTable, createTemporaryTable, createTemporaryTable, createTemporaryTableIfNotExists, createTemporaryTableIfNotExists, createTemporaryTableIfNotExists, createType, createType, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createView, createView, createView, createView, createView, createView, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, cube, cube, cumeDist, cumeDist, cumeDist, currentDate, currentInstant, currentLocalDate, currentLocalDateTime, currentLocalTime, currentOffsetDateTime, currentOffsetTime, currentSchema, currentTime, currentTimestamp, currentTimestamp, currentUser, date, date, date, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, day, day, day, dayOfWeek, dayOfWeek, dayOfWeek, dayOfYear, dayOfYear, dayOfYear, decade, decade, decade, declare, decode, decode, decode, decode, decode, default_, default_, default_, default_, defaultValue, defaultValue, defaultValue, defaultValue, deg, deg, delete, deleteFrom, denseRank, denseRank, denseRank, dropIndex, dropIndex, dropIndex, dropIndexIfExists, dropIndexIfExists, dropIndexIfExists, dropSchema, dropSchema, dropSchema, dropSchemaIfExists, dropSchemaIfExists, dropSchemaIfExists, dropSequence, dropSequence, dropSequence, dropSequenceIfExists, dropSequenceIfExists, dropSequenceIfExists, dropTable, dropTable, dropTable, dropTableIfExists, dropTableIfExists, dropTableIfExists, dropTemporaryTable, dropTemporaryTable, dropTemporaryTable, dropTemporaryTableIfExists, dropTemporaryTableIfExists, dropTemporaryTableIfExists, dropType, dropType, dropType, dropType, dropType, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropView, dropView, dropView, dropViewIfExists, dropViewIfExists, dropViewIfExists, dual, e, epoch, epoch, epoch, escape, escape, every, every, execute, execute, execute, exists, exit, exit, exitWhen, exp, exp, extract, extract, extract, falseCondition, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, fieldByName, fieldByName, fieldByName, firstValue, floor, floor, for_, 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, 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, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, getDataType, goto_, grant, grant, grant, greatest, greatest, groupConcat, groupConcat, groupConcatDistinct, groupId, grouping, groupingId, groupingSets, groupingSets, groupingSets, groupsBetweenCurrentRow, groupsBetweenFollowing, groupsBetweenPreceding, groupsBetweenUnboundedFollowing, groupsBetweenUnboundedPreceding, groupsCurrentRow, groupsFollowing, groupsPreceding, groupsUnboundedFollowing, groupsUnboundedPreceding, hour, hour, hour, if_, ifnull, ifnull, ifnull, ifnull, iif, iif, iif, iif, index, 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, 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, instant, instant, instant, isnull, isnull, isnull, isnull, isoDayOfWeek, isoDayOfWeek, isoDayOfWeek, jsonArray, jsonArray, jsonbArray, jsonbArray, jsonbObject, jsonbObject, jsonEntry, jsonObject, jsonObject, jsonObject, keyword, label, label, 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, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateDiff, localDateDiff, localDateDiff, localDateDiff, localDateSub, localDateSub, localDateSub, localDateSub, localDateSub, localDateSub, localDateTime, localDateTime, localDateTime, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localTime, localTime, localTime, log, log, log, loop, loop, lower, lower, lpad, lpad, lpad, lpad, lpad, ltrim, ltrim, 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, microsecond, microsecond, microsecond, mid, mid, millennium, millennium, millennium, millisecond, millisecond, millisecond, min, minDistinct, minus, minute, minute, minute, mode, mode, month, month, month, name, name, name, name, neg, noCondition, not, not, not, notExists, notUnique, now, now, 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, or, orderBy, orderBy, orderBy, param, param, param, param, param, param, param, param, param, partitionBy, partitionBy, percentileCont, percentileCont, percentileDisc, percentileDisc, percentRank, percentRank, percentRank, period, period, period, pi, position, position, position, position, position, position, position, position, position, position, position, position, power, power, power, power, primaryKey, primaryKey, primaryKey, prior, privilege, product, productDistinct, quarter, quarter, quarter, queries, queries, query, query, query, query, queryPart, queryPart, queryPart, quotedName, quotedName, quotedName, rad, rad, rand, rangeBetweenCurrentRow, rangeBetweenFollowing, rangeBetweenPreceding, rangeBetweenUnboundedFollowing, rangeBetweenUnboundedPreceding, rangeCurrentRow, rangeFollowing, rangePreceding, rangeUnboundedFollowing, rangeUnboundedPreceding, rank, 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, repeat, repeat, replace, replace, replace, replace, resultQuery, resultQuery, resultQuery, resultQuery, return_, return_, return_, reverse, reverse, revoke, revoke, revoke, revokeGrantOptionFor, revokeGrantOptionFor, revokeGrantOptionFor, right, right, right, right, role, role, rollup, rollup, round, 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, rowField, rownum, rowNumber, rowsBetweenCurrentRow, rowsBetweenFollowing, rowsBetweenPreceding, rowsBetweenUnboundedFollowing, rowsBetweenUnboundedPreceding, rowsCurrentRow, rowsFollowing, rowsFrom, rowsPreceding, rowsUnboundedFollowing, rowsUnboundedPreceding, rpad, rpad, rpad, rpad, rpad, rtrim, rtrim, 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, selectFrom, selectFrom, selectFrom, selectFrom, selectFrom, selectOne, selectZero, sequence, sequence, sequence, sequence, sequence, sequence, sequenceByName, sequenceByName, sequenceByName, set, setCatalog, setCatalog, setCatalog, setSchema, setSchema, setSchema, shl, shl, shl, shl, shr, shr, shr, shr, sign, sign, sin, sin, sinh, sinh, space, space, sql, sql, sql, sqrt, sqrt, statement, statement, statement, statement, statements, statements, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, systemTime, systemTime, systemTime, table, 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, timestampSub, timestampSub, timestampSub, timestampSub, timestampSub, timestampSub, timezone, timezone, timezone, timezoneHour, timezoneHour, timezoneHour, timezoneMinute, timezoneMinute, timezoneMinute, toDate, toDate, toDate, toDate, toLocalDate, toLocalDate, toLocalDate, toLocalDate, toLocalDateTime, toLocalDateTime, toLocalDateTime, toLocalDateTime, toTimestamp, toTimestamp, toTimestamp, toTimestamp, translate, translate, trim, trim, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, truncate, truncate, truncate, truncateTable, truncateTable, truncateTable, two, unique, unique, unique, unique, unnest, unnest, unnest, unnest, unquotedName, unquotedName, unquotedName, update, upper, upper, user, user, 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, 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, value, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, var, var, variable, variable, varPop, varSamp, week, week, week, when, when, when, while_, widthBucket, widthBucket, 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, 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, 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
-
-
-
-
Method Detail
-
decode
@Support({AURORA_MYSQL,MYSQL}) public static Field<String> decode(String cryptString, String keyString)
Get the MySQL-specificDECODE()
function.Don't mix this up with the various
DSL.decode()
methods!
-
decode
@Support({AURORA_MYSQL,MYSQL}) public static Field<byte[]> decode(byte[] cryptString, byte[] keyString)
Get the MySQL-specificDECODE()
function.Don't mix this up with the various
DSL.decode()
methods!
-
decode
@Support({AURORA_MYSQL,MYSQL}) public static <T> Field<T> decode(Field<T> cryptString, Field<T> keyString)
Get the MySQL-specificDECODE()
function.Don't mix this up with the various
DSL.decode()
methods!
-
encode
@Support({AURORA_MYSQL,MYSQL}) public static Field<String> encode(String string, String keyString)
Get the MySQL-specificENCODE()
function.
-
encode
@Support({AURORA_MYSQL,MYSQL}) public static Field<byte[]> encode(byte[] string, byte[] keyString)
Get the MySQL-specificENCODE()
function.
-
encode
@Support({AURORA_MYSQL,MYSQL}) public static <T> Field<T> encode(Field<T> string, Field<T> keyString)
Get the MySQL-specificENCODE()
function.
-
aesDecrypt
@Support({AURORA_MYSQL,MYSQL}) public static Field<String> aesDecrypt(String cryptString, String keyString)
Get the MySQL-specificAES_DECRYPT()
function.
-
aesDecrypt
@Support({AURORA_MYSQL,MYSQL}) public static Field<byte[]> aesDecrypt(byte[] cryptString, byte[] keyString)
Get the MySQL-specificAES_DECRYPT()
function.
-
aesDecrypt
@Support({AURORA_MYSQL,MYSQL}) public static <T> Field<T> aesDecrypt(Field<T> cryptString, Field<T> keyString)
Get the MySQL-specificAES_DECRYPT()
function.
-
aesEncrypt
@Support({AURORA_MYSQL,MYSQL}) public static Field<String> aesEncrypt(String string, String keyString)
Get the MySQL-specificAES_ENCRYPT()
function.
-
aesEncrypt
@Support({AURORA_MYSQL,MYSQL}) public static Field<byte[]> aesEncrypt(byte[] string, byte[] keyString)
Get the MySQL-specificAES_ENCRYPT()
function.
-
aesEncrypt
@Support({AURORA_MYSQL,MYSQL}) public static <T> Field<T> aesEncrypt(Field<T> string, Field<T> keyString)
Get the MySQL-specificAES_ENCRYPT()
function.
-
desDecrypt
@Support({AURORA_MYSQL,MYSQL}) public static Field<String> desDecrypt(String cryptString)
Get the MySQL-specificDES_DECRYPT()
function.
-
desDecrypt
@Support({AURORA_MYSQL,MYSQL}) public static Field<byte[]> desDecrypt(byte[] cryptString)
Get the MySQL-specificDES_DECRYPT()
function.
-
desDecrypt
@Support({AURORA_MYSQL,MYSQL}) public static <T> Field<T> desDecrypt(Field<T> cryptString)
Get the MySQL-specificDES_DECRYPT()
function.
-
desDecrypt
@Support({AURORA_MYSQL,MYSQL}) public static Field<String> desDecrypt(String cryptString, String keyString)
Get the MySQL-specificDES_DECRYPT()
function.
-
desDecrypt
@Support({AURORA_MYSQL,MYSQL}) public static Field<byte[]> desDecrypt(byte[] cryptString, byte[] keyString)
Get the MySQL-specificDES_DECRYPT()
function.
-
desDecrypt
@Support({AURORA_MYSQL,MYSQL}) public static <T> Field<T> desDecrypt(Field<T> cryptString, Field<T> keyString)
Get the MySQL-specificDES_DECRYPT()
function.
-
desEncrypt
@Support({AURORA_MYSQL,MYSQL}) public static Field<String> desEncrypt(String string)
Get the MySQL-specificDES_ENCRYPT()
function.
-
desEncrypt
@Support({AURORA_MYSQL,MYSQL}) public static Field<byte[]> desEncrypt(byte[] string)
Get the MySQL-specificDES_ENCRYPT()
function.
-
desEncrypt
@Support({AURORA_MYSQL,MYSQL}) public static <T> Field<T> desEncrypt(Field<T> string)
Get the MySQL-specificDES_ENCRYPT()
function.
-
desEncrypt
@Support({AURORA_MYSQL,MYSQL}) public static Field<String> desEncrypt(String string, String keyString)
Get the MySQL-specificDES_ENCRYPT()
function.
-
desEncrypt
@Support({AURORA_MYSQL,MYSQL}) public static Field<byte[]> desEncrypt(byte[] string, byte[] keyString)
Get the MySQL-specificDES_ENCRYPT()
function.
-
desEncrypt
@Support({AURORA_MYSQL,MYSQL}) public static <T> Field<T> desEncrypt(Field<T> string, Field<T> keyString)
Get the MySQL-specificDES_ENCRYPT()
function.
-
compress
@Support({AURORA_MYSQL,MYSQL}) public static Field<String> compress(String string)
Get the MySQL-specificCOMPRESS()
function.
-
compress
@Support({AURORA_MYSQL,MYSQL}) public static Field<byte[]> compress(byte[] string)
Get the MySQL-specificCOMPRESS()
function.
-
compress
@Support({AURORA_MYSQL,MYSQL}) public static <T> Field<T> compress(Field<T> string)
Get the MySQL-specificCOMPRESS()
function.
-
uncompress
@Support({AURORA_MYSQL,MYSQL}) public static Field<String> uncompress(String string)
Get the MySQL-specificUNCOMPRESS()
function.
-
uncompress
@Support({AURORA_MYSQL,MYSQL}) public static Field<byte[]> uncompress(byte[] string)
Get the MySQL-specificUNCOMPRESS()
function.
-
uncompress
@Support({AURORA_MYSQL,MYSQL}) public static <T> Field<T> uncompress(Field<T> string)
Get the MySQL-specificUNCOMPRESS()
function.
-
uncompressedLength
@Support({AURORA_MYSQL,MYSQL}) public static Field<Integer> uncompressedLength(String string)
Get the MySQL-specificUNCOMPRESSED_LENGTH()
function.
-
uncompressedLength
@Support({AURORA_MYSQL,MYSQL}) public static Field<Integer> uncompressedLength(byte[] string)
Get the MySQL-specificUNCOMPRESSED_LENGTH()
function.
-
uncompressedLength
@Support({AURORA_MYSQL,MYSQL}) public static <T> Field<Integer> uncompressedLength(Field<T> string)
Get the MySQL-specificUNCOMPRESSED_LENGTH()
function.
-
sha1
@Support({AURORA_MYSQL,MYSQL}) public static Field<String> sha1(String string)
Get the MySQL-specificSHA1()
function.
-
sha1
@Support({AURORA_MYSQL,MYSQL}) public static Field<byte[]> sha1(byte[] string)
Get the MySQL-specificSHA1()
function.
-
sha1
@Support({AURORA_MYSQL,MYSQL}) public static <T> Field<T> sha1(Field<T> string)
Get the MySQL-specificSHA1()
function.
-
sha2
@Support({AURORA_MYSQL,MYSQL}) public static Field<String> sha2(String string, int hashLength)
Get the MySQL-specificSHA2()
function.
-
sha2
@Support({AURORA_MYSQL,MYSQL}) public static Field<byte[]> sha2(byte[] string, int hashLength)
Get the MySQL-specificSHA2()
function.
-
sha2
@Support({AURORA_MYSQL,MYSQL}) public static <T> Field<T> sha2(Field<T> string, Field<Integer> hashLength)
Get the MySQL-specificSHA2()
function.
-
password
@Support({AURORA_MYSQL,MYSQL}) public static Field<String> password(String string)
Get the MySQL-specificPASSWORD()
function.
-
password
@Support({AURORA_MYSQL,MYSQL}) public static Field<byte[]> password(byte[] string)
Get the MySQL-specificPASSWORD()
function.
-
password
@Support({AURORA_MYSQL,MYSQL}) public static <T> Field<T> password(Field<T> string)
Get the MySQL-specificPASSWORD()
function.
-
values
@Support({AURORA_MYSQL,MEMSQL,MYSQL}) public static <T> Field<T> values(Field<T> values)
Get the MySQL-specificVALUES()
function for use withINSERT .. ON DUPLICATE KEY UPDATE
statements.
-
enumType
public static <E extends Enum<E> & EnumType> E enumType(Class<E> type, int index)
Get a field basedEnumType
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
-
-