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

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)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static @NotNull Field<String>

decode(String cryptString, String keyString)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static <T> @NotNull Field<T>

decode(Field<T> cryptString, Field<T> keyString)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static @NotNull Field<byte[]>

desDecrypt(byte[] cryptString)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static @NotNull Field<byte[]>

desDecrypt(byte[] cryptString, byte[] keyString)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static @NotNull Field<String>

desDecrypt(String cryptString)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static @NotNull Field<String>

desDecrypt(String cryptString, String keyString)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static <T> @NotNull Field<T>

desDecrypt(Field<T> cryptString)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static <T> @NotNull Field<T>

desDecrypt(Field<T> cryptString, Field<T> keyString)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static @NotNull Field<byte[]>

desEncrypt(byte[] string)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static @NotNull Field<byte[]>

desEncrypt(byte[] string, byte[] keyString)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static @NotNull Field<String>

desEncrypt(String string)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static @NotNull Field<String>

desEncrypt(String string, String keyString)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static <T> @NotNull Field<T>

desEncrypt(Field<T> string)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static <T> @NotNull Field<T>

desEncrypt(Field<T> string, Field<T> keyString)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static @NotNull Field<byte[]>

encode(byte[] string, byte[] keyString)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static @NotNull Field<String>

encode(String string, String keyString)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static <T> @NotNull Field<T>

encode(Field<T> string, Field<T> keyString)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

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)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static @NotNull Field<String>

password(String string)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

static <T> @NotNull Field<T>

password(Field<T> string)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#8611] - This function has been removed from MySQL 8

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)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.15.0 - [#12099] - MySQL 8.0.20 has deprecated this clause and replaced it by something new, which we'll support soon, see https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html/ and https://github.com/jOOQ/jOOQ/issues/12099

Methods inherited from class org.jooq.impl.DSL
abs, abs, acos, acos, acosh, acosh, acoth, acoth, 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, anyValue, array, array, array, array, arrayAgg, arrayAggDistinct, arrayGet, arrayGet, ascii, ascii, asin, asin, asinh, asinh, asterisk, atan, atan, atan2, atan2, atan2, atan2, atanh, atanh, avg, avgDistinct, begin, begin, bitAnd, bitAnd, bitAnd, bitAnd, bitAndAgg, bitCount, bitCount, bitLength, bitLength, bitNand, bitNand, bitNand, bitNand, bitNandAgg, bitNor, bitNor, bitNor, bitNor, bitNorAgg, bitNot, bitNot, bitOr, bitOr, bitOr, bitOr, bitOrAgg, bitXNor, bitXNor, bitXNor, bitXNor, bitXNorAgg, bitXor, bitXor, bitXor, bitXor, bitXorAgg, boolAnd, boolAnd, boolOr, boolOr, call, call, 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, chr, chr, coalesce, coalesce, coalesce, coerce, coerce, coerce, coerce, coerce, coerce, collation, collation, collect, collect, collectDistinct, collectDistinct, comment, commentOnColumn, 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, corr, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, count, count, countDistinct, countDistinct, countDistinct, countDistinct, covarPop, covarSamp, createDatabase, createDatabase, createDatabase, createDatabaseIfNotExists, createDatabaseIfNotExists, createDatabaseIfNotExists, createDomain, createDomain, createDomain, createDomainIfNotExists, createDomainIfNotExists, createDomainIfNotExists, createFunction, createFunction, createGlobalTemporaryTable, createGlobalTemporaryTable, createGlobalTemporaryTable, createGlobalTemporaryTableIfNotExists, createGlobalTemporaryTableIfNotExists, createGlobalTemporaryTableIfNotExists, createIndex, createIndex, createIndex, createIndex, createIndexIfNotExists, createIndexIfNotExists, createIndexIfNotExists, createIndexIfNotExists, createOrReplaceFunction, createOrReplaceFunction, createOrReplaceProcedure, createOrReplaceProcedure, createOrReplaceTrigger, createOrReplaceTrigger, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createProcedure, createProcedure, createSchema, createSchema, createSchema, createSchemaIfNotExists, createSchemaIfNotExists, createSchemaIfNotExists, createSequence, createSequence, createSequence, createSequenceIfNotExists, createSequenceIfNotExists, createSequenceIfNotExists, createTable, createTable, createTable, createTableIfNotExists, createTableIfNotExists, createTableIfNotExists, createTemporaryTable, createTemporaryTable, createTemporaryTable, createTemporaryTableIfNotExists, createTemporaryTableIfNotExists, createTemporaryTableIfNotExists, createTrigger, createTrigger, createType, createType, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createView, createView, createView, createView, createView, createView, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, cube, cube, cumeDist, cumeDist, cumeDist, currentCatalog, currentDate, currentInstant, currentLocalDate, currentLocalDateTime, currentLocalDateTime, currentLocalDateTime, currentLocalTime, currentOffsetDateTime, currentOffsetTime, currentSchema, currentTime, currentTimestamp, currentTimestamp, currentTimestamp, currentUser, date, date, date, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, day, day, day, dayOfWeek, dayOfWeek, dayOfWeek, dayOfYear, dayOfYear, dayOfYear, decade, decade, decade, declare, declare, declare, decode, decode, decode, decode, decode, default_, default_, default_, default_, defaultValue, defaultValue, defaultValue, defaultValue, deg, deg, delete, deleteFrom, deleting, denseRank, denseRank, denseRank, digits, digits, domain, domain, dropDatabase, dropDatabase, dropDatabase, dropDatabaseIfExists, dropDatabaseIfExists, dropDatabaseIfExists, dropDomain, dropDomain, dropDomain, dropDomainIfExists, dropDomainIfExists, dropDomainIfExists, dropFunction, dropFunction, dropFunctionIfExists, dropFunctionIfExists, dropIndex, dropIndex, dropIndex, dropIndexIfExists, dropIndexIfExists, dropIndexIfExists, dropProcedure, dropProcedure, dropProcedureIfExists, dropProcedureIfExists, dropSchema, dropSchema, dropSchema, dropSchemaIfExists, dropSchemaIfExists, dropSchemaIfExists, dropSequence, dropSequence, dropSequence, dropSequenceIfExists, dropSequenceIfExists, dropSequenceIfExists, dropTable, dropTable, dropTable, dropTableIfExists, dropTableIfExists, dropTableIfExists, dropTemporaryTable, dropTemporaryTable, dropTemporaryTable, dropTemporaryTableIfExists, dropTemporaryTableIfExists, dropTemporaryTableIfExists, dropTrigger, dropTrigger, dropTriggerIfExists, dropTriggerIfExists, dropType, dropType, dropType, dropType, dropType, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropView, dropView, dropView, dropViewIfExists, dropViewIfExists, dropViewIfExists, dual, e, emptyGroupingSet, epoch, epoch, epoch, escape, escape, every, every, excluded, 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, field, field, finalTable, finalTable, finalTable, 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, 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, in, in, 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, inline, inline, inlined, inlined, inlined, inlined, inOut, inOut, insert, insert, inserting, 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, jsonEntry, jsonEntry, jsonEntry, jsonExists, jsonExists, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObjectAgg, jsonObjectAgg, jsonObjectAgg, jsonObjectAgg, jsonTable, jsonTable, jsonValue, jsonValue, key, key, keyword, label, label, lag, lag, lag, lag, lag, lag, lag, lastValue, lateral, lead, lead, lead, 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, 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, localDateTimeAdd, localDateTimeAdd, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localTime, localTime, localTime, log, log, log, log, log10, log10, loop, loop, lower, lower, lpad, lpad, lpad, lpad, lpad, lpad, lpad, ltrim, ltrim, 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, mid, mid, mid, mid, millennium, millennium, millennium, millisecond, millisecond, millisecond, min, minDistinct, minus, minute, minute, minute, mode, mode, month, month, month, multiset, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, name, name, name, name, neg, newTable, newTable, newTable, noCondition, noField, noField, noField, noField, not, not, notExists, notUnique, now, now, nthValue, nthValue, ntile, ntile, nullCondition, nullif, nullif, nullif, nullif, nullSafe, nullSafe, nullSafe, nullSafe, nullSafeDataType, nullSafeList, nullSafeList, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, offsetDateTime, offsetDateTime, offsetDateTime, offsetTime, offsetTime, offsetTime, oldTable, oldTable, oldTable, one, or, or, or, orderBy, orderBy, orderBy, out, out, 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, primaryKey, prior, privilege, product, productDistinct, quarter, quarter, quarter, queries, queries, query, query, query, query, 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, 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, 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, rpad, rpad, rtrim, rtrim, rtrim, rtrim, rtrim, rtrim, schema, schema, 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, set, setCatalog, setCatalog, setCatalog, setLocal, setSchema, setSchema, setSchema, shl, shl, shl, shl, shr, shr, shr, shr, sign, sign, signalSQLState, signalSQLState, sin, sin, sinh, sinh, space, space, splitPart, splitPart, splitPart, splitPart, sql, sql, sql, sqrt, sqrt, square, square, stArea, stArea, stAsBinary, stAsBinary, stAsText, stAsText, statement, statement, statement, statement, statements, statements, stCentroid, stCentroid, stContains, stContains, stContains, stContains, stCrosses, stCrosses, stCrosses, stCrosses, stddevPop, stddevSamp, stDifference, stDifference, stDifference, stDifference, stDisjoint, stDisjoint, stDisjoint, stDisjoint, stDistance, stDistance, stDistance, stDistance, stEndPoint, stEndPoint, stEquals, stEquals, stEquals, stEquals, stExteriorRing, stExteriorRing, stGeometryN, stGeometryN, stGeometryN, stGeometryN, stGeometryType, stGeometryType, stGeomFromText, stGeomFromText, stGeomFromText, stGeomFromText, stGeomFromText, stGeomFromText, stGeomFromWKB, stGeomFromWKB, stGeomFromWKB, stGeomFromWKB, stGeomFromWKB, stGeomFromWKB, stInteriorRingN, stInteriorRingN, stInteriorRingN, stInteriorRingN, stIntersection, stIntersection, stIntersection, stIntersection, stIntersects, stIntersects, stIntersects, stIntersects, stIsClosed, stIsClosed, stIsEmpty, stIsEmpty, stLength, stLength, stNumGeometries, stNumGeometries, stNumInteriorRings, stNumInteriorRings, stNumPoints, stNumPoints, stOverlaps, stOverlaps, stOverlaps, stOverlaps, stPointN, stPointN, stPointN, stPointN, stSrid, stSrid, stStartPoint, stStartPoint, stTouches, stTouches, stTouches, stTouches, stUnion, stUnion, stUnion, stUnion, stWithin, stWithin, stWithin, stWithin, stX, stX, stY, stY, stZ, stZ, substring, substring, substring, substring, substring, substring, substringIndex, substringIndex, substringIndex, substringIndex, sum, sumDistinct, sysConnectByPath, systemName, systemName, systemName, systemTime, systemTime, systemTime, table, table, table, table, table, table, table, table, table, table, table, table, table, table, tan, tan, tanh, tanh, tau, time, time, time, timestamp, timestamp, timestamp, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampDiff, timestampDiff, timestampDiff, timestampDiff, 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, toHex, toHex, toLocalDate, toLocalDate, toLocalDate, toLocalDate, toLocalDateTime, toLocalDateTime, toLocalDateTime, toLocalDateTime, toTimestamp, toTimestamp, toTimestamp, toTimestamp, translate, translate, translate, translate, trim, trim, 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, unique, unnest, unnest, unnest, unnest, unquotedName, unquotedName, unquotedName, update, updating, upper, upper, user, user, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, uuid, 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, 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, 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, xmlserializeContent, xmlserializeContent, xmlserializeDocument, xmlserializeDocument, 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 Details
- MySQLDSL
  
  protected MySQLDSL()
  
  No instances
Method Details
- decode
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> decode(String cryptString, String keyString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DECODE() function.
  Don't mix this up with the various DSL.decode() methods!
- decode
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> decode(byte[] cryptString, byte[] keyString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DECODE() function.
  Don't mix this up with the various DSL.decode() methods!
- decode
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> decode(Field<T> cryptString, Field<T> keyString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DECODE() function.
  Don't mix this up with the various DSL.decode() methods!
- encode
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> encode(String string, String keyString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific ENCODE() function.
- encode
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> encode(byte[] string, byte[] keyString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific ENCODE() function.
- encode
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> encode(Field<T> string, Field<T> keyString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  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
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> desDecrypt(String cryptString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DES_DECRYPT() function.
- desDecrypt
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> desDecrypt(byte[] cryptString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DES_DECRYPT() function.
- desDecrypt
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> desDecrypt(Field<T> cryptString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DES_DECRYPT() function.
- desDecrypt
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> desDecrypt(String cryptString, String keyString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DES_DECRYPT() function.
- desDecrypt
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> desDecrypt(byte[] cryptString, byte[] keyString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DES_DECRYPT() function.
- desDecrypt
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> desDecrypt(Field<T> cryptString, Field<T> keyString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DES_DECRYPT() function.
- desEncrypt
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> desEncrypt(String string)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DES_ENCRYPT() function.
- desEncrypt
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> desEncrypt(byte[] string)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DES_ENCRYPT() function.
- desEncrypt
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> desEncrypt(Field<T> string)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DES_ENCRYPT() function.
- desEncrypt
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> desEncrypt(String string, String keyString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DES_ENCRYPT() function.
- desEncrypt
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> desEncrypt(byte[] string, byte[] keyString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DES_ENCRYPT() function.
- desEncrypt
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> desEncrypt(Field<T> string, Field<T> keyString)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific DES_ENCRYPT() function.
- compress
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> compress(String string)
  
  Get the MySQL-specific COMPRESS() function.
- compress
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> compress(byte[] string)
  
  Get the MySQL-specific COMPRESS() function.
- compress
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> compress(Field<T> string)
  
  Get the MySQL-specific COMPRESS() function.
- uncompress
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> uncompress(String string)
  
  Get the MySQL-specific UNCOMPRESS() function.
- uncompress
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> uncompress(byte[] string)
  
  Get the MySQL-specific UNCOMPRESS() function.
- uncompress
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> uncompress(Field<T> string)
  
  Get the MySQL-specific UNCOMPRESS() function.
- uncompressedLength
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<Integer> uncompressedLength(String string)
  
  Get the MySQL-specific UNCOMPRESSED_LENGTH() function.
- uncompressedLength
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<Integer> uncompressedLength(byte[] string)
  
  Get the MySQL-specific UNCOMPRESSED_LENGTH() function.
- uncompressedLength
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<Integer> uncompressedLength(Field<T> string)
  
  Get the MySQL-specific UNCOMPRESSED_LENGTH() function.
- sha1
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> sha1(String string)
  
  Get the MySQL-specific SHA1() function.
- sha1
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> sha1(byte[] string)
  
  Get the MySQL-specific SHA1() function.
- sha1
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> sha1(Field<T> string)
  
  Get the MySQL-specific SHA1() function.
- sha2
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> sha2(String string, int hashLength)
  
  Get the MySQL-specific SHA2() function.
- sha2
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> sha2(byte[] string, int hashLength)
  
  Get the MySQL-specific SHA2() function.
- sha2
  
  @NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> sha2(Field<T> string, Field<Integer> hashLength)
  
  Get the MySQL-specific SHA2() function.
- password
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> password(String string)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific PASSWORD() function.
- password
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> password(byte[] string)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific PASSWORD() function.
- password
  
  @Deprecated(forRemoval=true, since="3.15") @NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> password(Field<T> string)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#8611] - This function has been removed from MySQL 8
  
  Get the MySQL-specific PASSWORD() function.
- values
  
  @Deprecated(forRemoval=true) @NotNull @Support({AURORA_MYSQL,MEMSQL,MYSQL}) public static <T> @NotNull Field<T> values(Field<T> values)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.15.0 - [#12099] - MySQL 8.0.20 has deprecated this clause and replaced it by something new, which we'll support soon, see https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html/ and https://github.com/jOOQ/jOOQ/issues/12099
  
  Get the MySQL-specific VALUES() function for use with INSERT … ON DUPLICATE KEY UPDATE statements.
  See Also:
  
  http://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html# function_values
- 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

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`

Class MySQLDSL

Constructor Summary

Method Summary

Methods inherited from class org.jooq.impl.DSL

Methods inherited from class java.lang.Object

Constructor Details

MySQLDSL

Method Details

decode

decode

decode

encode

encode

encode

aesDecrypt

aesDecrypt

aesDecrypt

aesEncrypt

aesEncrypt

aesEncrypt

desDecrypt

desDecrypt

desDecrypt

desDecrypt

desDecrypt

desDecrypt

desEncrypt

desEncrypt

desEncrypt

desEncrypt

desEncrypt

desEncrypt

compress

compress

compress

uncompress

uncompress

uncompress

uncompressedLength

uncompressedLength

uncompressedLength

sha1

sha1

sha1

sha2

sha2

sha2

password

password

password

values

enumType