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

Constructor Summary

Constructors
Modifier Constructor Description

protected MySQLDSL()
No instances

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method	Description
`static @NotNull Field<byte[]>`	`aesDecrypt(byte[] cryptString, byte[] keyString)`	Get the MySQL-specific `AES_DECRYPT()` function.
`static @NotNull Field<String>`	`aesDecrypt(String cryptString, String keyString)`	Get the MySQL-specific `AES_DECRYPT()` function.
`static <T> @NotNull Field<T>`	`aesDecrypt(Field<T> cryptString, Field<T> keyString)`	Get the MySQL-specific `AES_DECRYPT()` function.
`static @NotNull Field<byte[]>`	`aesEncrypt(byte[] string, byte[] keyString)`	Get the MySQL-specific `AES_ENCRYPT()` function.
`static @NotNull Field<String>`	`aesEncrypt(String string, String keyString)`	Get the MySQL-specific `AES_ENCRYPT()` function.
`static <T> @NotNull Field<T>`	`aesEncrypt(Field<T> string, Field<T> keyString)`	Get the MySQL-specific `AES_ENCRYPT()` function.
`static @NotNull Field<byte[]>`	`compress(byte[] string)`	Get the MySQL-specific `COMPRESS()` function.
`static @NotNull Field<String>`	`compress(String string)`	Get the MySQL-specific `COMPRESS()` function.
`static <T> @NotNull Field<T>`	`compress(Field<T> string)`	Get the MySQL-specific `COMPRESS()` function.
`static @NotNull Field<byte[]>`	`decode(byte[] cryptString, byte[] keyString)`	Get the MySQL-specific `DECODE()` function.
`static @NotNull Field<String>`	`decode(String cryptString, String keyString)`	Get the MySQL-specific `DECODE()` function.
`static <T> @NotNull Field<T>`	`decode(Field<T> cryptString, Field<T> keyString)`	Get the MySQL-specific `DECODE()` function.
`static @NotNull Field<byte[]>`	`desDecrypt(byte[] cryptString)`	Get the MySQL-specific `DES_DECRYPT()` function.
`static @NotNull Field<byte[]>`	`desDecrypt(byte[] cryptString, byte[] keyString)`	Get the MySQL-specific `DES_DECRYPT()` function.
`static @NotNull Field<String>`	`desDecrypt(String cryptString)`	Get the MySQL-specific `DES_DECRYPT()` function.
`static @NotNull Field<String>`	`desDecrypt(String cryptString, String keyString)`	Get the MySQL-specific `DES_DECRYPT()` function.
`static <T> @NotNull Field<T>`	`desDecrypt(Field<T> cryptString)`	Get the MySQL-specific `DES_DECRYPT()` function.
`static <T> @NotNull Field<T>`	`desDecrypt(Field<T> cryptString, Field<T> keyString)`	Get the MySQL-specific `DES_DECRYPT()` function.
`static @NotNull Field<byte[]>`	`desEncrypt(byte[] string)`	Get the MySQL-specific `DES_ENCRYPT()` function.
`static @NotNull Field<byte[]>`	`desEncrypt(byte[] string, byte[] keyString)`	Get the MySQL-specific `DES_ENCRYPT()` function.
`static @NotNull Field<String>`	`desEncrypt(String string)`	Get the MySQL-specific `DES_ENCRYPT()` function.
`static @NotNull Field<String>`	`desEncrypt(String string, String keyString)`	Get the MySQL-specific `DES_ENCRYPT()` function.
`static <T> @NotNull Field<T>`	`desEncrypt(Field<T> string)`	Get the MySQL-specific `DES_ENCRYPT()` function.
`static <T> @NotNull Field<T>`	`desEncrypt(Field<T> string, Field<T> keyString)`	Get the MySQL-specific `DES_ENCRYPT()` function.
`static @NotNull Field<byte[]>`	`encode(byte[] string, byte[] keyString)`	Get the MySQL-specific `ENCODE()` function.
`static @NotNull Field<String>`	`encode(String string, String keyString)`	Get the MySQL-specific `ENCODE()` function.
`static <T> @NotNull Field<T>`	`encode(Field<T> string, Field<T> 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.
`static @NotNull Field<byte[]>`	`password(byte[] string)`	Get the MySQL-specific `PASSWORD()` function.
`static @NotNull Field<String>`	`password(String string)`	Get the MySQL-specific `PASSWORD()` function.
`static <T> @NotNull Field<T>`	`password(Field<T> string)`	Get the MySQL-specific `PASSWORD()` function.
`static @NotNull Field<byte[]>`	`sha1(byte[] string)`	Get the MySQL-specific `SHA1()` function.
`static @NotNull Field<String>`	`sha1(String string)`	Get the MySQL-specific `SHA1()` function.
`static <T> @NotNull Field<T>`	`sha1(Field<T> string)`	Get the MySQL-specific `SHA1()` function.
`static @NotNull Field<byte[]>`	`sha2(byte[] string, int hashLength)`	Get the MySQL-specific `SHA2()` function.
`static @NotNull Field<String>`	`sha2(String string, int hashLength)`	Get the MySQL-specific `SHA2()` function.
`static <T> @NotNull Field<T>`	`sha2(Field<T> string, Field<Integer> hashLength)`	Get the MySQL-specific `SHA2()` function.
`static @NotNull Field<byte[]>`	`uncompress(byte[] string)`	Get the MySQL-specific `UNCOMPRESS()` function.
`static @NotNull Field<String>`	`uncompress(String string)`	Get the MySQL-specific `UNCOMPRESS()` function.
`static <T> @NotNull Field<T>`	`uncompress(Field<T> string)`	Get the MySQL-specific `UNCOMPRESS()` function.
`static @NotNull Field<Integer>`	`uncompressedLength(byte[] string)`	Get the MySQL-specific `UNCOMPRESSED_LENGTH()` function.
`static @NotNull Field<Integer>`	`uncompressedLength(String string)`	Get the MySQL-specific `UNCOMPRESSED_LENGTH()` function.
`static <T> @NotNull Field<Integer>`	`uncompressedLength(Field<T> string)`	Get the MySQL-specific `UNCOMPRESSED_LENGTH()` function.
`static <T> @NotNull Field<T>`	`values(Field<T> values)`	Get the MySQL-specific `VALUES()` function for use with `INSERT ..`

Methods inherited from class org.jooq.impl.DSL
abs, abs, acos, acos, aggregate, aggregate, aggregate, aggregate, aggregateDistinct, aggregateDistinct, aggregateDistinct, aggregateDistinct, all, all, all, all, alterDatabase, alterDatabase, alterDatabase, alterDatabaseIfExists, alterDatabaseIfExists, alterDatabaseIfExists, alterDomain, alterDomain, alterDomain, alterDomainIfExists, alterDomainIfExists, alterDomainIfExists, 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, arrayGet, arrayGet, 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, cardinality, case_, case_, case_, cast, cast, cast, cast, cast, cast, castNull, castNull, castNull, catalog, 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, continueWhen, convert, convert, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, count, count, countDistinct, countDistinct, countDistinct, countDistinct, createDatabase, createDatabase, createDatabase, createDatabaseIfNotExists, createDatabaseIfNotExists, createDatabaseIfNotExists, createDomain, createDomain, createDomain, createDomainIfNotExists, createDomainIfNotExists, createDomainIfNotExists, 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, 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, domain, domain, dropDatabase, dropDatabase, dropDatabase, dropDatabaseIfExists, dropDatabaseIfExists, dropDatabaseIfExists, dropDomain, dropDomain, dropDomain, dropDomainIfExists, dropDomainIfExists, dropDomainIfExists, 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, 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_, if_, if_, if_, 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, inline, inline, inline, insert, insert, 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, jsonArrayAgg, jsonbArray, jsonbArray, jsonbArrayAgg, jsonbExists, jsonbExists, jsonbObject, jsonbObject, jsonbObject, jsonbObjectAgg, jsonbObjectAgg, jsonbObjectAgg, jsonbObjectAgg, jsonbTable, jsonbTable, jsonbValue, jsonbValue, jsonEntry, jsonEntry, jsonEntry, jsonEntry, jsonExists, jsonExists, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObjectAgg, jsonObjectAgg, jsonObjectAgg, jsonObjectAgg, jsonTable, jsonTable, jsonValue, jsonValue, key, key, 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, 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, nullSafeList, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, offsetDateTime, offsetDateTime, offsetDateTime, offsetTime, offsetTime, offsetTime, one, or, or, or, orderBy, orderBy, orderBy, overlay, overlay, overlay, overlay, 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, regexpReplaceAll, regexpReplaceAll, regexpReplaceFirst, regexpReplaceFirst, 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, 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, tau, 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, toChar, toChar, toChar, toChar, toChar, toChar, 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, 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, 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, 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, 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, withRecursive, withRecursive, withRecursive, xmlagg, xmlattributes, xmlattributes, xmlcomment, xmlcomment, xmlconcat, xmlconcat, xmldocument, xmlelement, xmlelement, xmlelement, xmlelement, xmlelement, xmlelement, xmlelement, xmlelement, xmlexists, xmlexists, xmlforest, xmlforest, xmlparseContent, xmlparseContent, xmlparseDocument, xmlparseDocument, xmlpi, xmlpi, xmlpi, xmlpi, xmlquery, xmlquery, xmltable, xmltable, year, year, year, zero

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail
- MySQLDSL
```
protected MySQLDSL()
```
  No instances

Method Detail

decode

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static @NotNull 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

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static @NotNull Field<byte[]> decode(byte[] cryptString,
                                            byte[] keyString)

Get the MySQL-specific DECODE() function.

Don't mix this up with the various DSL.decode() methods!

decode

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static <T> @NotNull Field<T> decode(Field<T> cryptString,
                                           Field<T> keyString)

Get the MySQL-specific DECODE() function.

Don't mix this up with the various DSL.decode() methods!

encode

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static @NotNull Field<String> encode(String string,
                                            String keyString)

Get the MySQL-specific ENCODE() function.

encode

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static @NotNull Field<byte[]> encode(byte[] string,
                                            byte[] keyString)

Get the MySQL-specific ENCODE() function.

encode

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static <T> @NotNull Field<T> encode(Field<T> string,
                                           Field<T> keyString)

Get the MySQL-specific ENCODE() function.

aesDecrypt

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static @NotNull Field<String> aesDecrypt(String cryptString,
                                                String keyString)

Get the MySQL-specific AES_DECRYPT() function.

aesDecrypt

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static @NotNull Field<byte[]> aesDecrypt(byte[] cryptString,
                                                byte[] keyString)

Get the MySQL-specific AES_DECRYPT() function.

aesDecrypt

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static <T> @NotNull Field<T> aesDecrypt(Field<T> cryptString,
                                               Field<T> keyString)

Get the MySQL-specific AES_DECRYPT() function.

aesEncrypt

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static @NotNull Field<String> aesEncrypt(String string,
                                                String keyString)

Get the MySQL-specific AES_ENCRYPT() function.

aesEncrypt

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static @NotNull Field<byte[]> aesEncrypt(byte[] string,
                                                byte[] keyString)

Get the MySQL-specific AES_ENCRYPT() function.

aesEncrypt

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static <T> @NotNull Field<T> aesEncrypt(Field<T> string,
                                               Field<T> keyString)

Get the MySQL-specific AES_ENCRYPT() function.

desDecrypt

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static @NotNull Field<String> desDecrypt(String cryptString)

Get the MySQL-specific DES_DECRYPT() function.

desDecrypt

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static @NotNull Field<byte[]> desDecrypt(byte[] cryptString)

Get the MySQL-specific DES_DECRYPT() function.

desDecrypt

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static <T> @NotNull Field<T> desDecrypt(Field<T> cryptString)

Get the MySQL-specific DES_DECRYPT() function.

desDecrypt

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static @NotNull Field<String> desDecrypt(String cryptString,
                                                String keyString)

Get the MySQL-specific DES_DECRYPT() function.

desDecrypt

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static @NotNull Field<byte[]> desDecrypt(byte[] cryptString,
                                                byte[] keyString)

Get the MySQL-specific DES_DECRYPT() function.

desDecrypt

@NotNull
@Support({AURORA_MYSQL,MYSQL})
public static <T> @NotNull Field<T> desDecrypt(Field<T> cryptString,
                                               Field<T> keyString)

Get the MySQL-specific DES_DECRYPT() function.