Class Atk4\Data\Persistence\Sql\Mysql\Query

`extends`	`Query`
`uses`	`ExpressionTrait`

Atk4\Data\Persistence\Sql\Expression implements Expressionable, ArrayAccess<int|string, mixed> uses DiContainerTrait
- Atk4\Data\Persistence\Sql\Query
  - Atk4\Data\Persistence\Sql\Mysql\Query uses ExpressionTrait

Located at data/src/Persistence/Sql/Mysql/Query.php

Methods
`public`	`groupConcat($field, string $separator = ',')` Returns a query for a function, which can be used as part of the GROUP query which would concatenate all matching… Returns a query for a function, which can be used as part of the GROUP query which would concatenate all matching fields. Overrides `Atk4\Data\Persistence\Sql\Query::groupConcat()`	#

Methods inherited from Atk4\Data\Persistence\Sql\Query
field(), _renderField(), _renderFieldNoalias(), table(), getMainTable(), _renderTable(), _renderTableNoalias(), _renderFrom(), with(), _renderWith(), join(), _renderJoin(), where(), having(), _subrenderWhere(), _renderConditionBinary(), _renderConditionInOperator(), _subrenderCondition(), _renderWhere(), _renderOrwhere(), _renderAndwhere(), _renderHaving(), group(), _renderGroup(), set(), setMulti(), _renderSet(), _renderSetFields(), _renderSetValues(), option(), _renderOption(), order(), deduplicateRenderOrder(), _renderOrder(), limit(), _renderLimit(), exists(), __debugInfo(), render(), renderNested(), mode(), expr(), dsql(), exprNow(), orExpr(), andExpr(), caseExpr(), caseWhen(), caseElse(), _renderCase(), _setArgs()

Methods inherited from Atk4\Data\Persistence\Sql\Query

field(), _renderField(), _renderFieldNoalias(), table(), getMainTable(), _renderTable(), _renderTableNoalias(), _renderFrom(), with(), _renderWith(), join(), _renderJoin(), where(), having(), _subrenderWhere(), _renderConditionBinary(), _renderConditionInOperator(), _subrenderCondition(), _renderWhere(), _renderOrwhere(), _renderAndwhere(), _renderHaving(), group(), _renderGroup(), set(), setMulti(), _renderSet(), _renderSetFields(), _renderSetValues(), option(), _renderOption(), order(), deduplicateRenderOrder(), _renderOrder(), limit(), _renderLimit(), exists(), __debugInfo(), render(), renderNested(), mode(), expr(), dsql(), exprNow(), orExpr(), andExpr(), caseExpr(), caseWhen(), caseElse(), _renderCase(), _setArgs()

Methods inherited from Atk4\Data\Persistence\Sql\Expression
`__construct(), getDsqlExpression(), offsetExists(), offsetGet(), offsetSet(), offsetUnset(), reset(), consume(), escapeParam(), escapeStringLiteral(), escapeIdentifier(), escapeIdentifierSoft(), isUnescapableIdentifier(), getDebugQuery(), hasNativeNamedParamSupport(), updateRenderBeforeExecute(), _executeStatement(), _execute(), executeQuery(), executeStatement(), castFloatToString(), getRowsIterator(), getRows(), getRow(), getOne()`

Methods inherited from Atk4\Data\Persistence\Sql\Expression

__construct(), getDsqlExpression(), offsetExists(), offsetGet(), offsetSet(), offsetUnset(), reset(), consume(), escapeParam(), escapeStringLiteral(), escapeIdentifier(), escapeIdentifierSoft(), isUnescapableIdentifier(), getDebugQuery(), hasNativeNamedParamSupport(), updateRenderBeforeExecute(), _executeStatement(), _execute(), executeQuery(), executeStatement(), castFloatToString(), getRowsIterator(), getRows(), getRow(), getOne()

Methods used from Atk4\Core\DiContainerTrait
`setDefaults(), setMissingProperty(), assertInstanceOf(), _fromSeedPrecheck(), fromSeed(), fromSeedUnsafe()`

Methods used from Atk4\Data\Persistence\Sql\Mysql\ExpressionTrait
`escapeStringLiteral(), hasNativeNamedParamSupport(), updateRenderBeforeExecute()`

Constants inherited from Atk4\Data\Persistence\Sql\Expression
`ESCAPE_PARAM, ESCAPE_IDENTIFIER, ESCAPE_IDENTIFIER_SOFT, ESCAPE_NONE, QUOTED_TOKEN_REGEX`

Properties
`protected`	`string`	$identifierEscapeChar = '`'	#
`protected`	`string`	`$expressionClass = Expression::class`	#
`protected`	`array`	`$supportedOperators = ['=', '!=', '<', '>', '<=', '>=', 'like', 'not like', 'in', 'not in', 'regexp', 'not regexp']`	#
`protected`	`string`	`$templateUpdate = 'update [table][join] set [set] [where]'`	#

Properties inherited from Atk4\Data\Persistence\Sql\Query
`$mode, $defaultField, $wrapInParentheses, $templateSelect, $templateInsert, $templateReplace, $templateDelete, $templateTruncate`

Properties inherited from Atk4\Data\Persistence\Sql\Expression
`$template, $args, $paramBase, $renderParamBase, $renderParams, $connection,`

Namespaces

Classes

Traits

Class Atk4\Data\Persistence\Sql\Mysql\Query

Overrides