Module org.jooq

Class MySQLDSL

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 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