java.lang.Object
- org.jooq.impl.DSL
- - org.jooq.util.mariadb.MariaDBDSL

```
public class MariaDBDSL
extends DSL
```
The SQLDialect.MARIADB specific DSL.

Author:

Lukas Eder

Constructor Summary

Constructors
Modifier Constructor Description

protected MariaDBDSL()
No instances

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method	Description
`static Field<java.lang.String>`	`aesDecrypt(java.lang.String cryptString, java.lang.String keyString)`	Get the MariaDB-specific `AES_DECRYPT()` function
`static Field<java.lang.String>`	`aesDecrypt(Field<java.lang.String> cryptString, Field<java.lang.String> keyString)`	Get the MariaDB-specific `AES_DECRYPT()` function
`static Field<java.lang.String>`	`aesEncrypt(java.lang.String string, java.lang.String keyString)`	Get the MariaDB-specific `AES_ENCRYPT()` function
`static Field<java.lang.String>`	`aesEncrypt(Field<java.lang.String> string, Field<java.lang.String> keyString)`	Get the MariaDB-specific `AES_ENCRYPT()` function
`static Field<java.lang.String>`	`compress(java.lang.String string)`	Get the MariaDB-specific `COMPRESS()` function
`static Field<java.lang.String>`	`compress(Field<java.lang.String> string)`	Get the MariaDB-specific `COMPRESS()` function
`static Field<java.lang.String>`	`decode(java.lang.String cryptString, java.lang.String keyString)`	Get the MariaDB-specific `DECODE()` function
`static Field<java.lang.String>`	`decode(Field<java.lang.String> cryptString, Field<java.lang.String> keyString)`	Get the MariaDB-specific `DECODE()` function
`static Field<java.lang.String>`	`desDecrypt(java.lang.String cryptString)`	Get the MariaDB-specific `DES_DECRYPT()` function
`static Field<java.lang.String>`	`desDecrypt(java.lang.String cryptString, java.lang.String keyString)`	Get the MariaDB-specific `DES_DECRYPT()` function
`static Field<java.lang.String>`	`desDecrypt(Field<java.lang.String> cryptString)`	Get the MariaDB-specific `DES_DECRYPT()` function
`static Field<java.lang.String>`	`desDecrypt(Field<java.lang.String> cryptString, Field<java.lang.String> keyString)`	Get the MariaDB-specific `DES_DECRYPT()` function
`static Field<java.lang.String>`	`desEncrypt(java.lang.String string)`	Get the MariaDB-specific `DES_ENCRYPT()` function
`static Field<java.lang.String>`	`desEncrypt(java.lang.String string, java.lang.String keyString)`	Get the MariaDB-specific `DES_ENCRYPT()` function
`static Field<java.lang.String>`	`desEncrypt(Field<java.lang.String> string)`	Get the MariaDB-specific `DES_ENCRYPT()` function
`static Field<java.lang.String>`	`desEncrypt(Field<java.lang.String> string, Field<java.lang.String> keyString)`	Get the MariaDB-specific `DES_ENCRYPT()` function
`static Field<java.lang.String>`	`encode(java.lang.String string, java.lang.String keyString)`	Get the MariaDB-specific `ENCODE()` function
`static Field<java.lang.String>`	`encode(Field<java.lang.String> string, Field<java.lang.String> keyString)`	Get the MariaDB-specific `ENCODE()` function
`static <E extends java.lang.Enum<E> & EnumType> E`	`enumType(java.lang.Class<E> type, int index)`	Get a field based `EnumType` by its MariaDB-specific index.
`static Field<java.lang.String>`	`password(java.lang.String string)`	Get the MariaDB-specific `PASSWORD()` function
`static Field<java.lang.String>`	`password(Field<java.lang.String> string)`	Get the MariaDB-specific `PASSWORD()` function
`static Field<java.lang.String>`	`sha1(java.lang.String string)`	Get the MariaDB-specific `SHA1()` function
`static Field<java.lang.String>`	`sha1(Field<java.lang.String> string)`	Get the MariaDB-specific `SHA1()` function
`static Field<java.lang.String>`	`uncompress(java.lang.String string)`	Get the MariaDB-specific `UNCOMPRESS()` function
`static Field<java.lang.String>`	`uncompress(Field<java.lang.String> string)`	Get the MariaDB-specific `UNCOMPRESS()` function
`static Field<java.lang.Integer>`	`uncompressedLength(java.lang.String string)`	Get the MariaDB-specific `UNCOMPRESSED_LENGTH()` function
`static Field<java.lang.Integer>`	`uncompressedLength(Field<java.lang.String> string)`	Get the MariaDB-specific `UNCOMPRESSED_LENGTH()` function

Methods inherited from class org.jooq.impl.DSL
abs, abs, acos, acos, all, all, all, all, alterIndex, alterIndex, alterIndex, alterIndexIfExists, alterIndexIfExists, alterIndexIfExists, alterSchema, alterSchema, alterSchema, alterSchemaIfExists, alterSchemaIfExists, alterSchemaIfExists, alterSequence, alterSequence, alterSequence, alterSequenceIfExists, alterSequenceIfExists, alterSequenceIfExists, alterTable, alterTable, alterTable, alterTableIfExists, alterTableIfExists, alterTableIfExists, alterView, alterView, alterView, alterViewIfExists, alterViewIfExists, alterViewIfExists, and, and, and, any, any, any, any, array, array, array, arrayAgg, arrayAggDistinct, ascii, ascii, asin, asin, asterisk, atan, atan, atan2, atan2, atan2, atan2, avg, avgDistinct, begin, begin, bitAnd, bitAnd, bitAnd, bitAnd, bitCount, bitCount, bitLength, bitLength, bitNand, bitNand, bitNand, bitNand, bitNor, bitNor, bitNor, bitNor, bitNot, bitNot, bitOr, bitOr, bitOr, bitOr, bitXNor, bitXNor, bitXNor, bitXNor, bitXor, bitXor, bitXor, bitXor, boolAnd, boolAnd, boolOr, boolOr, case_, case_, case_, cast, cast, cast, cast, cast, cast, castNull, castNull, castNull, catalog, ceil, ceil, century, century, century, characterSet, characterSet, charLength, charLength, check, choose, choose, choose, choose, choose, choose, choose, coalesce, coalesce, coalesce, coerce, coerce, coerce, coerce, coerce, coerce, collation, collation, collect, collect, collectDistinct, collectDistinct, comment, commentOnColumn, commentOnColumn, commentOnTable, commentOnTable, commentOnTable, commentOnView, commentOnView, commentOnView, concat, concat, concat, concat, condition, condition, condition, condition, condition, condition, condition, condition, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, constraint, constraint, constraint, continue_, continue_, continueWhen, convert, convert, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, count, count, countDistinct, countDistinct, countDistinct, countDistinct, createGlobalTemporaryTable, createGlobalTemporaryTable, createGlobalTemporaryTable, createIndex, createIndex, createIndex, createIndex, createIndexIfNotExists, createIndexIfNotExists, createIndexIfNotExists, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createSchema, createSchema, createSchema, createSchemaIfNotExists, createSchemaIfNotExists, createSchemaIfNotExists, createSequence, createSequence, createSequence, createSequenceIfNotExists, createSequenceIfNotExists, createSequenceIfNotExists, createTable, createTable, createTable, createTableIfNotExists, createTableIfNotExists, createTableIfNotExists, createTemporaryTable, createTemporaryTable, createTemporaryTable, createType, createType, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createView, createView, createView, createView, createView, createView, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, cube, cube, cumeDist, cumeDist, cumeDist, currentDate, currentInstant, currentLocalDate, currentLocalDateTime, currentLocalTime, currentOffsetDateTime, currentOffsetTime, currentSchema, currentTime, currentTimestamp, currentTimestamp, currentUser, date, date, date, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, day, day, day, dayOfWeek, dayOfWeek, dayOfWeek, dayOfYear, dayOfYear, dayOfYear, decade, decade, decade, declare, decode, decode, decode, decode, decode, default_, default_, default_, default_, defaultValue, defaultValue, defaultValue, defaultValue, deg, deg, delete, deleteFrom, denseRank, denseRank, denseRank, dropIndex, dropIndex, dropIndex, dropIndexIfExists, dropIndexIfExists, dropIndexIfExists, dropSchema, dropSchema, dropSchema, dropSchemaIfExists, dropSchemaIfExists, dropSchemaIfExists, dropSequence, dropSequence, dropSequence, dropSequenceIfExists, dropSequenceIfExists, dropSequenceIfExists, dropTable, dropTable, dropTable, dropTableIfExists, dropTableIfExists, dropTableIfExists, dropTemporaryTable, dropTemporaryTable, dropTemporaryTable, 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, exists, exit, exit, exitWhen, exp, exp, extract, extract, extract, falseCondition, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, fieldByName, fieldByName, fieldByName, firstValue, floor, floor, for_, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, function, function, function, function, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, getDataType, goto_, grant, grant, grant, greatest, greatest, groupConcat, groupConcat, groupConcatDistinct, groupId, grouping, groupingId, groupingSets, groupingSets, groupingSets, groupsBetweenCurrentRow, groupsBetweenFollowing, groupsBetweenPreceding, groupsBetweenUnboundedFollowing, groupsBetweenUnboundedPreceding, groupsCurrentRow, groupsFollowing, groupsPreceding, groupsUnboundedFollowing, groupsUnboundedPreceding, hour, hour, hour, if_, ifnull, ifnull, ifnull, ifnull, iif, iif, iif, iif, index, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, instant, instant, instant, isnull, isnull, isnull, isnull, isoDayOfWeek, isoDayOfWeek, isoDayOfWeek, jsonArray, jsonArray, jsonbArray, jsonbArray, jsonbObject, jsonbObject, jsonEntry, jsonObject, jsonObject, jsonObject, keyword, label, label, lag, lag, lag, lag, lastValue, lateral, lead, lead, lead, lead, least, least, left, left, left, left, length, length, level, link, link, link, list, list, listAgg, listAgg, ln, ln, localDate, localDate, localDate, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateDiff, localDateDiff, localDateDiff, localDateDiff, localDateSub, localDateSub, localDateSub, localDateSub, localDateSub, localDateSub, localDateTime, localDateTime, localDateTime, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localTime, localTime, localTime, log, log, log, loop, loop, lower, lower, lpad, lpad, lpad, lpad, lpad, ltrim, ltrim, ltrim, ltrim, max, maxDistinct, md5, md5, median, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, microsecond, microsecond, microsecond, mid, mid, millennium, millennium, millennium, millisecond, millisecond, millisecond, min, minDistinct, minus, minute, minute, minute, mode, mode, month, month, month, name, name, name, name, neg, noCondition, not, not, not, notExists, notUnique, now, now, nthValue, nthValue, ntile, nullif, nullif, nullif, nullif, nullSafe, nullSafe, nullSafe, nullSafeDataType, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, offsetDateTime, offsetDateTime, offsetDateTime, offsetTime, offsetTime, offsetTime, one, or, or, or, orderBy, orderBy, orderBy, param, param, param, param, param, param, param, param, param, partitionBy, partitionBy, percentileCont, percentileCont, percentileDisc, percentileDisc, percentRank, percentRank, percentRank, pi, position, position, position, position, position, position, position, position, position, position, position, position, power, power, power, power, primaryKey, primaryKey, primaryKey, prior, privilege, product, productDistinct, quarter, quarter, quarter, queries, queries, query, query, query, query, queryPart, queryPart, queryPart, quotedName, quotedName, quotedName, rad, rad, rand, rangeBetweenCurrentRow, rangeBetweenFollowing, rangeBetweenPreceding, rangeBetweenUnboundedFollowing, rangeBetweenUnboundedPreceding, rangeCurrentRow, rangeFollowing, rangePreceding, rangeUnboundedFollowing, rangeUnboundedPreceding, rank, rank, rank, ratioToReport, ratioToReport, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, repeat, repeat, repeat, repeat, repeat, repeat, replace, replace, replace, replace, resultQuery, resultQuery, resultQuery, resultQuery, reverse, reverse, revoke, revoke, revoke, revokeGrantOptionFor, revokeGrantOptionFor, revokeGrantOptionFor, right, right, right, right, role, role, rollup, rollup, round, round, round, round, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rownum, rowNumber, rowsBetweenCurrentRow, rowsBetweenFollowing, rowsBetweenPreceding, rowsBetweenUnboundedFollowing, rowsBetweenUnboundedPreceding, rowsCurrentRow, rowsFollowing, rowsFrom, rowsPreceding, rowsUnboundedFollowing, rowsUnboundedPreceding, rpad, rpad, rpad, rpad, rpad, rtrim, rtrim, rtrim, rtrim, schema, schemaByName, second, second, second, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, selectCount, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectFrom, selectFrom, selectFrom, selectFrom, selectFrom, selectFrom, selectOne, selectZero, sequence, sequence, sequence, sequence, sequence, sequence, sequenceByName, sequenceByName, sequenceByName, 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, statements, statements, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, table, table, table, table, table, table, table, table, table, table, table, table, table, table, tableByName, tan, tan, tanh, tanh, time, time, time, timestamp, timestamp, timestamp, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampDiff, timestampDiff, timestampDiff, timestampDiff, timestampSub, timestampSub, timestampSub, timestampSub, timestampSub, timestampSub, timezone, timezone, timezone, timezoneHour, timezoneHour, timezoneHour, timezoneMinute, timezoneMinute, timezoneMinute, toDate, toDate, toDate, toDate, toLocalDate, toLocalDate, toLocalDate, toLocalDate, toLocalDateTime, toLocalDateTime, toLocalDateTime, toLocalDateTime, toTimestamp, toTimestamp, toTimestamp, toTimestamp, translate, translate, trim, trim, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, truncate, truncate, truncate, truncateTable, truncateTable, truncateTable, two, unique, unique, unique, unique, unnest, unnest, unnest, unnest, unquotedName, unquotedName, unquotedName, update, upper, upper, user, user, using, using, using, using, using, using, using, using, using, using, using, using, using, using, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, var, var, variable, variable, varPop, varSamp, week, week, week, when, when, when, while_, widthBucket, widthBucket, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, year, year, year, zero

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

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

Method Detail

decode

public static Field<java.lang.String> decode(java.lang.String cryptString,
                                             java.lang.String keyString)

Get the MariaDB-specific DECODE() function

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

decode

public static Field<java.lang.String> decode(Field<java.lang.String> cryptString,
                                             Field<java.lang.String> keyString)

Get the MariaDB-specific DECODE() function

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

encode

public static Field<java.lang.String> encode(java.lang.String string,
                                             java.lang.String keyString)

Get the MariaDB-specific ENCODE() function

encode

public static Field<java.lang.String> encode(Field<java.lang.String> string,
                                             Field<java.lang.String> keyString)

Get the MariaDB-specific ENCODE() function

aesDecrypt

public static Field<java.lang.String> aesDecrypt(java.lang.String cryptString,
                                                 java.lang.String keyString)

Get the MariaDB-specific AES_DECRYPT() function

aesDecrypt

public static Field<java.lang.String> aesDecrypt(Field<java.lang.String> cryptString,
                                                 Field<java.lang.String> keyString)

Get the MariaDB-specific AES_DECRYPT() function

aesEncrypt

public static Field<java.lang.String> aesEncrypt(java.lang.String string,
                                                 java.lang.String keyString)

Get the MariaDB-specific AES_ENCRYPT() function

aesEncrypt

public static Field<java.lang.String> aesEncrypt(Field<java.lang.String> string,
                                                 Field<java.lang.String> keyString)

Get the MariaDB-specific AES_ENCRYPT() function

desDecrypt

public static Field<java.lang.String> desDecrypt(java.lang.String cryptString)

Get the MariaDB-specific DES_DECRYPT() function

desDecrypt

public static Field<java.lang.String> desDecrypt(Field<java.lang.String> cryptString)

Get the MariaDB-specific DES_DECRYPT() function

desDecrypt

public static Field<java.lang.String> desDecrypt(java.lang.String cryptString,
                                                 java.lang.String keyString)

Get the MariaDB-specific DES_DECRYPT() function

desDecrypt

public static Field<java.lang.String> desDecrypt(Field<java.lang.String> cryptString,
                                                 Field<java.lang.String> keyString)

Get the MariaDB-specific DES_DECRYPT() function

desEncrypt

public static Field<java.lang.String> desEncrypt(java.lang.String string)

Get the MariaDB-specific DES_ENCRYPT() function

desEncrypt

public static Field<java.lang.String> desEncrypt(Field<java.lang.String> string)

Get the MariaDB-specific DES_ENCRYPT() function

desEncrypt

public static Field<java.lang.String> desEncrypt(java.lang.String string,
                                                 java.lang.String keyString)

Get the MariaDB-specific DES_ENCRYPT() function

desEncrypt

public static Field<java.lang.String> desEncrypt(Field<java.lang.String> string,
                                                 Field<java.lang.String> keyString)

Get the MariaDB-specific DES_ENCRYPT() function

compress

public static Field<java.lang.String> compress(java.lang.String string)

Get the MariaDB-specific COMPRESS() function

compress

public static Field<java.lang.String> compress(Field<java.lang.String> string)

Get the MariaDB-specific COMPRESS() function

uncompress

public static Field<java.lang.String> uncompress(java.lang.String string)

Get the MariaDB-specific UNCOMPRESS() function

uncompress

public static Field<java.lang.String> uncompress(Field<java.lang.String> string)

Get the MariaDB-specific UNCOMPRESS() function

uncompressedLength

public static Field<java.lang.Integer> uncompressedLength(java.lang.String string)

Get the MariaDB-specific UNCOMPRESSED_LENGTH() function

uncompressedLength

public static Field<java.lang.Integer> uncompressedLength(Field<java.lang.String> string)

Get the MariaDB-specific UNCOMPRESSED_LENGTH() function

sha1

public static Field<java.lang.String> sha1(java.lang.String string)

Get the MariaDB-specific SHA1() function

sha1

public static Field<java.lang.String> sha1(Field<java.lang.String> string)

Get the MariaDB-specific SHA1() function

password

public static Field<java.lang.String> password(java.lang.String string)

Get the MariaDB-specific PASSWORD() function

password

public static Field<java.lang.String> password(Field<java.lang.String> string)

Get the MariaDB-specific PASSWORD() function

enumType
```
public static <E extends java.lang.Enum<E> & EnumType> E enumType(java.lang.Class<E> type,
                                                                  int index)
```
Get a field based EnumType by its MariaDB-specific index.
If your MariaDB 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() MariaDB 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()`	MariaDB index
`null`	`-`	`0`
`A`	`0`	`1`
`B`	`1`	`2`
`C`	`2`	`3`

Class MariaDBDSL

Constructor Summary

Method Summary

Methods inherited from class org.jooq.impl.DSL

Methods inherited from class java.lang.Object

Constructor Detail

MariaDBDSL

Method Detail

decode

decode

encode

encode

aesDecrypt

aesDecrypt

aesEncrypt

aesEncrypt

desDecrypt

desDecrypt

desDecrypt

desDecrypt

desEncrypt

desEncrypt

desEncrypt

desEncrypt

compress

compress

uncompress

uncompress

uncompressedLength

uncompressedLength

sha1

sha1

password

password

enumType