Class MySqlDialect

java.lang.Object

org.springframework.data.relational.core.dialect.AbstractDialect

org.springframework.data.relational.core.dialect.MySqlDialect

All Implemented Interfaces:

Dialect

Direct Known Subclasses:

MariaDbDialect

public class MySqlDialect
extends AbstractDialect

A SQL dialect for MySQL.

Since:

1.1

Author:

Mark Paluch, Jens Schauder, Myeonghyeon Lee

Field Summary

Fields

Modifier and Type	Field	Description
static final MySqlDialect	INSTANCE	Deprecated, for removal: This API element is subject to removal in a future version. use either the org.springframework.data.r2dbc.dialect.MySqlDialect or org.springframework.data.jdbc.core.dialect.JdbcMySqlDialect
static final IdentifierProcessing	MYSQL_IDENTIFIER_PROCESSING	Deprecated, for removal: This API element is subject to removal in a future version. Construct your own IdentifierProcessing.

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	MySqlDialect()
	MySqlDialect(IdentifierProcessing identifierProcessing)	Creates a new MySqlDialect given IdentifierProcessing.

Method Summary

Modifier and Type	Method	Description
Collection<Object>	getConverters()	Return a collection of converters for this dialect.
IdentifierProcessing	getIdentifierProcessing()	Returns the handling of table- and column names (identifiers) used for processing SqlIdentifier when converting them to SQL snippets or parameter names.
IdGeneration	getIdGeneration()	Returns the IdGeneration used for generating identifiers.
UpsertRenderContext	getUpsertRenderContext()	Returns an UpsertRenderContext for single-statement upsert.
LimitClause	limit()	Return the LimitClause used by this dialect.
LockClause	lock()	Return the LockClause used by this dialect.
OrderByNullPrecedence	orderByNullHandling()	Return the OrderByNullPrecedence used by this dialect.

Methods inherited from class AbstractDialect

getAfterFromTable, getAfterOrderBy, getSelectContext

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface Dialect

getArraySupport, getExistsFunction, getInsertRenderContext, getLikeEscaper, getName, simpleTypes, supportsSingleQueryLoading

Field Details

MYSQL_IDENTIFIER_PROCESSING

@Deprecated(forRemoval=true,
            since="4.0")
public static final IdentifierProcessing MYSQL_IDENTIFIER_PROCESSING

Deprecated, for removal: This API element is subject to removal in a future version.

Construct your own IdentifierProcessing. There is no one standard identifier processing for MySql. See Identifier Case Sensitivity.

MySQL defaults for IdentifierProcessing.

INSTANCE

@Deprecated(forRemoval=true)
public static final MySqlDialect INSTANCE

Deprecated, for removal: This API element is subject to removal in a future version.

use either the org.springframework.data.r2dbc.dialect.MySqlDialect or org.springframework.data.jdbc.core.dialect.JdbcMySqlDialect

Singleton instance.

Constructor Details

MySqlDialect

protected MySqlDialect()

MySqlDialect

public MySqlDialect(IdentifierProcessing identifierProcessing)

Creates a new MySqlDialect given IdentifierProcessing.

Parameters:

identifierProcessing - must not be null.

Since:

2.0

Method Details

getIdentifierProcessing

public IdentifierProcessing getIdentifierProcessing()

Description copied from interface: Dialect

Returns the handling of table- and column names (identifiers) used for processing SqlIdentifier when converting them to SQL snippets or parameter names.

Returns:

the IdentifierProcessing. Guaranteed to be not null.

getIdGeneration

public IdGeneration getIdGeneration()

Description copied from interface: Dialect

Returns the IdGeneration used for generating identifiers.

Returns:

the IdGeneration used for generating identifiers.

lock

public LockClause lock()

Description copied from interface: Dialect

Return the LockClause used by this dialect.

Returns:

the LockClause used by this dialect.

getConverters

public Collection<Object> getConverters()

Description copied from interface: Dialect

Return a collection of converters for this dialect.

Returns:

a collection of converters for this dialect.

limit

public LimitClause limit()

Description copied from interface: Dialect

Return the LimitClause used by this dialect.

Returns:

the LimitClause used by this dialect.

orderByNullHandling

public OrderByNullPrecedence orderByNullHandling()

Description copied from interface: Dialect

Return the OrderByNullPrecedence used by this dialect.

Returns:

the OrderByNullPrecedence used by this dialect.

getUpsertRenderContext

public UpsertRenderContext getUpsertRenderContext()

Description copied from interface: Dialect

Returns an UpsertRenderContext for single-statement upsert.

Returns:

the upsert render context, defaults to standard MERGE.