SIMULTANEOUS_ASSIGNMENT
This page is part of MariaDB's Documentation.
The parent of this page is: SQL Modes
Topics on this page:
Overview
In 11.4 ES, 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS:
This mode causes the server to evaluate all assignments in the
SET
clause of an UPDATE statement at the same time, rather than from left-to-right.
In 11.4 ES, 10.6 ES, 10.5 ES, 10.4 ES:
This mode causes the server to evaluate all assignments in the
SET
clause of an UPDATE statement at the same time, rather than from left-to-right.
In 10.2 ES, 10.2 CS:
Not present
See also: SQL Modes, in 10.6 ES, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS
See also: SQL Modes, in 10.6 ES, in 10.5 ES, and in 10.4 ES
USAGE
DETAILS
SYNONYMS
SCHEMA
PARAMETERS
SKYSQL
PRIVILEGES
EXAMPLES
ERROR HANDLING
FEATURE INTERACTION
RESPONSES
DIAGNOSIS
ISO 9075:2016
CHANGE HISTORY
Release Series | History |
---|---|
11.4 Enterprise |
|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
Release Series | History |
---|---|
11.4 Enterprise |
|
10.6 Enterprise |
|
10.5 Enterprise |
|
10.4 Enterprise |
|