Open nene opened 1 year ago
Most of MariaDB syntax is the same as MySQL. This issue lists only the differences.
->
->>
MEMBER OF
SQL_CACHE
WITH ROLLUP
ORDER BY
ROWS EXAMINED rows_limit
OFFSET start {ROW ROWS}
FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } { ONLY | WITH TIES }
PROCEDURE
FOR SHARE
FOR UPDATE
LOCK IN SHARE MODE
lock_option
FROM
{ OJ }
LATERAL
NATURAL INNER JOIN
FOR SYSTEM_TIME
PARTITION
MINUS {ALL | DISTINCT}
UNION
FOR PORTION OF period FROM _ TO _
RETURNING
DELETE HISTORY
WITH
PARTITION (..)
CONSTRAINT [name]
CHECK()
PRIMARY KEY
FOREIGN KEY
UNIQUE
[NOT] ENFORCED
TABLE[S]
IF EXISTS
WAIT n | NOWAIT
ALTER [ONLINE] [IGNORE] TABLE
RENAME [AS]
RENAME [TO]
ADD [COLUMN] [IF NOT EXISTS]
ADD [CONSTRAINT [symbol]] FOREIGN KEY [IF NOT EXISTS] ...
DROP CONSTRAINT IF EXISTS
ALTER CONSTRAINT
DROP CHECK
ALTER COLUMN SET {VISIBLE | INVISIBLE}
Most of MariaDB syntax is the same as MySQL. This issue lists only the differences.
Expressions
->,->>)MEMBER OFoperatorQuery syntax
SQL_CACHEmodifierWITH ROLLUPinORDER BYROWS EXAMINED rows_limitOFFSET start {ROW ROWS}FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } { ONLY | WITH TIES }PROCEDUREclauseFOR SHARE(onlyFOR UPDATE)LOCK IN SHARE MODEwithlock_optionparameter (I've found no examples of thislock_optionbeing used).FROMclause:{ OJ }syntaxLATERALNATURAL INNER JOINFOR SYSTEM_TIMEspecification (combined withPARTITION)MINUS {ALL | DISTINCT}in addition toUNIONetc.Statements
FOR PORTION OF period FROM _ TO _RETURNINGclauseDELETE HISTORYWITHclauseFOR PORTION OF period FROM _ TO _WITHclausePARTITION (..)clauseRETURNINGclauseDDL Statements
CONSTRAINT [name]can only be used withCHECK(),PRIMARY KEY,FOREIGN KEY,UNIQUE.[NOT] ENFORCEDmodifier onCHECK()(or any other) constraint.TABLE[S]IF EXISTSWAIT n | NOWAITWAIT n | NOWAITALTER [ONLINE] [IGNORE] TABLEIF EXISTSWAIT n | NOWAITRENAME [AS], onlyRENAME [TO]ADD [COLUMN] [IF NOT EXISTS]ADD [CONSTRAINT [symbol]] FOREIGN KEY [IF NOT EXISTS] ...DROP CONSTRAINT IF EXISTSALTER CONSTRAINTDROP CHECKALTER COLUMN SET {VISIBLE | INVISIBLE}