java.lang.Object
org.jooq.impl.DSL
org.jooq.util.mysql.MySQLDSL
The
SQLDialect.MYSQL
specific DSL.- Author:
- Lukas Eder
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionstatic @NotNull Field
<byte[]> aesDecrypt
(byte[] cryptString, byte[] keyString) Get the MySQL-specificAES_DECRYPT()
function.aesDecrypt
(String cryptString, String keyString) Get the MySQL-specificAES_DECRYPT()
function.static <T> @NotNull Field
<T> aesDecrypt
(Field<T> cryptString, Field<T> keyString) Get the MySQL-specificAES_DECRYPT()
function.static @NotNull Field
<byte[]> aesEncrypt
(byte[] string, byte[] keyString) Get the MySQL-specificAES_ENCRYPT()
function.aesEncrypt
(String string, String keyString) Get the MySQL-specificAES_ENCRYPT()
function.static <T> @NotNull Field
<T> aesEncrypt
(Field<T> string, Field<T> keyString) Get the MySQL-specificAES_ENCRYPT()
function.static @NotNull Field
<byte[]> compress
(byte[] string) Get the MySQL-specificCOMPRESS()
function.Get the MySQL-specificCOMPRESS()
function.static <T> @NotNull Field
<T> Get the MySQL-specificCOMPRESS()
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 8Deprecated, for removal: This API element is subject to removal in a future version.- 3.15.0 - [#8611] - This function has been removed from MySQL 8static <T> @NotNull Field
<T> 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 8static @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 8static @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 8desDecrypt
(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 8desDecrypt
(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 8static <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 8static <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 8static @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 8static @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 8desEncrypt
(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 8desEncrypt
(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 8static <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 8static <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 8static @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 8Deprecated, for removal: This API element is subject to removal in a future version.- 3.15.0 - [#8611] - This function has been removed from MySQL 8static <T> @NotNull Field
<T> 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 8Get a field basedEnumType
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 8Deprecated, for removal: This API element is subject to removal in a future version.- 3.15.0 - [#8611] - This function has been removed from MySQL 8static <T> @NotNull Field
<T> 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 8static @NotNull Field
<byte[]> sha1
(byte[] string) Get the MySQL-specificSHA1()
function.Get the MySQL-specificSHA1()
function.static <T> @NotNull Field
<T> Get the MySQL-specificSHA1()
function.static @NotNull Field
<byte[]> sha2
(byte[] string, int hashLength) Get the MySQL-specificSHA2()
function.Get the MySQL-specificSHA2()
function.static <T> @NotNull Field
<T> Get the MySQL-specificSHA2()
function.static @NotNull Field
<byte[]> uncompress
(byte[] string) Get the MySQL-specificUNCOMPRESS()
function.uncompress
(String string) Get the MySQL-specificUNCOMPRESS()
function.static <T> @NotNull Field
<T> uncompress
(Field<T> string) Get the MySQL-specificUNCOMPRESS()
function.uncompressedLength
(byte[] string) Get the MySQL-specificUNCOMPRESSED_LENGTH()
function.uncompressedLength
(String string) Get the MySQL-specificUNCOMPRESSED_LENGTH()
function.uncompressedLength
(Field<T> string) Get the MySQL-specificUNCOMPRESSED_LENGTH()
function.static <T> @NotNull Field
<T> 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/12099Methods 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, alterMaterializedView, alterMaterializedView, alterMaterializedView, alterMaterializedViewIfExists, alterMaterializedViewIfExists, alterMaterializedViewIfExists, alterSchema, alterSchema, alterSchema, alterSchemaIfExists, alterSchemaIfExists, alterSchemaIfExists, alterSequence, alterSequence, alterSequence, alterSequenceIfExists, alterSequenceIfExists, alterSequenceIfExists, alterTable, alterTable, alterTable, alterTableIfExists, alterTableIfExists, alterTableIfExists, alterType, alterType, alterTypeIfExists, alterTypeIfExists, alterView, alterView, alterView, alterView, alterView, alterViewIfExists, alterViewIfExists, alterViewIfExists, and, and, and, any, any, any, any, anyValue, array, array, array, array, arrayAgg, arrayAggDistinct, arrayAppend, arrayAppend, arrayAppend, arrayAppend, arrayConcat, arrayConcat, arrayConcat, arrayConcat, arrayGet, arrayGet, arrayOverlap, arrayOverlap, arrayOverlap, arrayOverlap, arrayPrepend, arrayPrepend, arrayPrepend, arrayPrepend, arrayRemove, arrayRemove, arrayRemove, arrayRemove, arrayReplace, arrayReplace, 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, bitGet, bitGet, bitLength, bitLength, bitNand, bitNand, bitNand, bitNand, bitNandAgg, bitNor, bitNor, bitNor, bitNor, bitNorAgg, bitNot, bitNot, bitOr, bitOr, bitOr, bitOr, bitOrAgg, bitSet, bitSet, bitSet, bitSet, bitSet, bitSet, 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, commentOnMaterializedView, commentOnMaterializedView, commentOnMaterializedView, commentOnTable, commentOnTable, commentOnTable, commentOnView, commentOnView, commentOnView, commit, 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, createMaterializedView, createMaterializedView, createMaterializedView, createMaterializedView, createMaterializedView, createMaterializedView, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createOrReplaceFunction, createOrReplaceFunction, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceProcedure, createOrReplaceProcedure, createOrReplaceTrigger, createOrReplaceTrigger, createOrReplaceTrigger, createOrReplaceView, createOrReplaceView, createOrReplaceView, 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, createTrigger, createType, createType, createType, createTypeIfNotExists, createTypeIfNotExists, createTypeIfNotExists, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createView, createView, createView, createView, createView, createView, createView, createView, createView, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, 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, domain, domain, domain, domain, dropDatabase, dropDatabase, dropDatabase, dropDatabaseIfExists, dropDatabaseIfExists, dropDatabaseIfExists, dropDomain, dropDomain, dropDomain, dropDomainIfExists, dropDomainIfExists, dropDomainIfExists, dropFunction, dropFunction, dropFunctionIfExists, dropFunctionIfExists, dropIndex, dropIndex, dropIndex, dropIndexIfExists, dropIndexIfExists, dropIndexIfExists, dropMaterializedView, dropMaterializedView, dropMaterializedView, dropMaterializedViewIfExists, dropMaterializedViewIfExists, dropMaterializedViewIfExists, 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, dropTrigger, dropTriggerIfExists, dropTriggerIfExists, dropTriggerIfExists, dropType, dropType, dropType, dropType, dropType, dropType, dropType, dropTypeIfExists, dropTypeIfExists, 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, jsonArrayAggDistinct, jsonbArray, jsonbArray, jsonbArrayAgg, jsonbArrayAggDistinct, jsonbExists, jsonbExists, jsonbGetAttribute, jsonbGetAttribute, jsonbGetAttribute, jsonbGetAttribute, jsonbGetAttributeAsText, jsonbGetAttributeAsText, jsonbGetAttributeAsText, jsonbGetAttributeAsText, jsonbGetElement, jsonbGetElement, jsonbGetElement, jsonbGetElement, jsonbGetElementAsText, jsonbGetElementAsText, jsonbGetElementAsText, jsonbGetElementAsText, jsonbInsert, jsonbInsert, jsonbInsert, jsonbInsert, jsonbKeys, jsonbKeys, jsonbObject, jsonbObject, jsonbObject, jsonbObject, jsonbObject, jsonbObject, jsonbObject, jsonbObjectAgg, jsonbObjectAgg, jsonbObjectAgg, jsonbObjectAgg, jsonbRemove, jsonbRemove, jsonbReplace, jsonbReplace, jsonbReplace, jsonbReplace, jsonbSet, jsonbSet, jsonbSet, jsonbSet, jsonbTable, jsonbTable, jsonbValue, jsonbValue, jsonEntry, jsonEntry, jsonEntry, jsonEntry, jsonEntry, jsonEntry, jsonEntry, jsonExists, jsonExists, jsonGetAttribute, jsonGetAttribute, jsonGetAttribute, jsonGetAttribute, jsonGetAttributeAsText, jsonGetAttributeAsText, jsonGetAttributeAsText, jsonGetAttributeAsText, jsonGetElement, jsonGetElement, jsonGetElement, jsonGetElement, jsonGetElementAsText, jsonGetElementAsText, jsonGetElementAsText, jsonGetElementAsText, jsonInsert, jsonInsert, jsonInsert, jsonInsert, jsonKeys, jsonKeys, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObjectAgg, jsonObjectAgg, jsonObjectAgg, jsonObjectAgg, jsonRemove, jsonRemove, jsonReplace, jsonReplace, jsonReplace, jsonReplace, jsonSet, jsonSet, jsonSet, jsonSet, 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, listAggDistinct, listAggDistinct, 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, multisetAgg, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, name, name, name, name, neg, newTable, newTable, newTable, noCondition, noField, noField, noField, noField, not, not, noTable, 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, raw, 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, releaseSavepoint, releaseSavepoint, 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, rollback, 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, savepoint, savepoint, 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, set, setCatalog, setCatalog, setCatalog, setLocal, 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, startTransaction, 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, trigger, trigger, 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, truncate, truncate, truncate, truncate, truncateTable, truncateTable, truncateTable, truncateTable, truncateTable, truncateTable, truncateTable, tryCast, tryCast, two, type, type, type, type, 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, xor, xor, xor, year, year, year, zero
-
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 8Get the MySQL-specificDECODE()
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 8Get the MySQL-specificDECODE()
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 8Get the MySQL-specificDECODE()
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 8Get the MySQL-specificENCODE()
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 8Get the MySQL-specificENCODE()
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 8Get the MySQL-specificENCODE()
function. -
aesDecrypt
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> aesDecrypt(String cryptString, String keyString) Get the MySQL-specificAES_DECRYPT()
function. -
aesDecrypt
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> aesDecrypt(byte[] cryptString, byte[] keyString) Get the MySQL-specificAES_DECRYPT()
function. -
aesDecrypt
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> aesDecrypt(Field<T> cryptString, Field<T> keyString) Get the MySQL-specificAES_DECRYPT()
function. -
aesEncrypt
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> aesEncrypt(String string, String keyString) Get the MySQL-specificAES_ENCRYPT()
function. -
aesEncrypt
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> aesEncrypt(byte[] string, byte[] keyString) Get the MySQL-specificAES_ENCRYPT()
function. -
aesEncrypt
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> aesEncrypt(Field<T> string, Field<T> keyString) Get the MySQL-specificAES_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 8Get the MySQL-specificDES_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 8Get the MySQL-specificDES_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 8Get the MySQL-specificDES_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 8Get the MySQL-specificDES_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 8Get the MySQL-specificDES_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 8Get the MySQL-specificDES_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 8Get the MySQL-specificDES_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 8Get the MySQL-specificDES_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 8Get the MySQL-specificDES_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 8Get the MySQL-specificDES_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 8Get the MySQL-specificDES_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 8Get the MySQL-specificDES_ENCRYPT()
function. -
compress
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> compress(String string) Get the MySQL-specificCOMPRESS()
function. -
compress
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> compress(byte[] string) Get the MySQL-specificCOMPRESS()
function. -
compress
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> compress(Field<T> string) Get the MySQL-specificCOMPRESS()
function. -
uncompress
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> uncompress(String string) Get the MySQL-specificUNCOMPRESS()
function. -
uncompress
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> uncompress(byte[] string) Get the MySQL-specificUNCOMPRESS()
function. -
uncompress
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> uncompress(Field<T> string) Get the MySQL-specificUNCOMPRESS()
function. -
uncompressedLength
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<Integer> uncompressedLength(String string) Get the MySQL-specificUNCOMPRESSED_LENGTH()
function. -
uncompressedLength
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<Integer> uncompressedLength(byte[] string) Get the MySQL-specificUNCOMPRESSED_LENGTH()
function. -
uncompressedLength
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<Integer> uncompressedLength(Field<T> string) Get the MySQL-specificUNCOMPRESSED_LENGTH()
function. -
sha1
Get the MySQL-specificSHA1()
function. -
sha1
Get the MySQL-specificSHA1()
function. -
sha1
Get the MySQL-specificSHA1()
function. -
sha2
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<String> sha2(String string, int hashLength) Get the MySQL-specificSHA2()
function. -
sha2
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static @NotNull Field<byte[]> sha2(byte[] string, int hashLength) Get the MySQL-specificSHA2()
function. -
sha2
@NotNull @Support({AURORA_MYSQL,MYSQL}) public static <T> @NotNull Field<T> sha2(Field<T> string, Field<Integer> hashLength) Get the MySQL-specificSHA2()
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 8Get the MySQL-specificPASSWORD()
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 8Get the MySQL-specificPASSWORD()
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 8Get the MySQL-specificPASSWORD()
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/12099Get the MySQL-specificVALUES()
function for use withINSERT … ON DUPLICATE KEY UPDATE
statements.- See Also:
-
enumType
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
-