þþ Nׇ¹Bÿÿÿÿÿÿÿÿ #Àÿ €ÿÿÿÿÿÿÿÿe½Áe½Áð?ð?œŽÁìî·¸Þé¶‘ €äî ï!  Ð @ ÅÆ!ÀÄÀÀÆ Ð Ú V        "$&(*   !"#$%&' ()*+,- . /0123456789:; < = > ?@AB C D E F G H I J KL M NOPQRS TUVWXYZ[ \ ]^_`ab cde fg"hijk"lm"n"o>p@q>r@s@tBuDvwDxy z {|H}H~H€JJ‚JƒJ„L…L†‡LˆL‰NŠN‹NŒŽ ‘’“ ”•P–N—R˜ ™"š" ›RœRRž" Ÿ> T¡R¢>£T¤V¥>¦@§V¨X©Xª@«B¬D­X®Z¯X°Z±\²\³\´^µ^¶^·`¸`¹bºb»D¼b½d¾d¿fÀHÁHÂfÃfÄH ÅJÆhÇhÈhÉjÊlËhÌnÍpÎjÏrÐlÑJ ÒJ ÓLÔnÕpÖL ×rØrÙtÚtÛtÜtÝtÞvßvàváL âxãxäxåxæLçzèNézêzëzìN íN îNïNðNñPòR ózôR õ|ö~÷Rø|ù€ú~û€ü‚ý„þ‚ÿ†ˆ‚Š„ˆŠŒŒŽ Ž    ’’T’T”–T–T T V–œžVV–  !V "¢#ž$¤%¦&X' (ª)¢*¤+¬,¬-®.¬/®0X 1Z2°3°4°5Z6°7²8Z9°:´;Z <¶=²>\?\@\ A\ B\C\D´E`F`G¶H`I` J¶K¸L¸M` NbO¸P¸Q¸RºS¼TºU¾VÀWÂXÀYbZb [È\È]d^È_È`ÐaÐbÒcÐdÔedfÔgÖhÖiØjÚkÖlÖmØnÜoÜpÜqÞrÞsÞtÞuàvàwàxâyâzä{æ|â}ä~èè€èè‚êƒê„ì…ê†ê‡îˆð‰dŠd ‹òŒôòŽööö‘ø’ú“ú”ú•d –ü—ü˜ü™þšd›þœžfŸ ¡¢£ ¤ ¥¦§¨©ª«¬­®¯°±²³´µ ¶·"¸$¹º»¼f½¾f ¿hÀÁ&Â(à Äh Å"Æ(Ç,È,É,Ê.Ë0Ì0Í2Îh Ï2Ð4Ñ4ÒhÓ8Ô8Õ:Öh×hØ8ÙDÚFÛDÜhÝjÞHßDàHáJâLãjäLåZæZçZèjéj êj ëlìlílînïbðbñnòbónôpõböb÷pørùdúdûrüdýfþhÿddfhjr r rt t  j j t p tppptrrtvvrvvv xxxv v x!x"z#z$x %x &z'x(z)~*~+x,~-~.€/€0z 1€2€3‚4‚5|6|7‚8„9„:„;†<†=†>|?| @| A~B~C€D€E€F€ G€ H€I€J€K€L€M€N€O€P‚Q†R‚S‚ T‚ U‚V‚W„X„Y†Zˆ[†\Š]†^†_†`† a† b†c†d†e†f†g†hŠiŠjŠk†lˆmŒnˆoŠpŒqŒrŒsŒ tŒuŽvŒwŽxŽyŽzŽ{Ž|Ž}Ž ~€’’‚’ƒ”„”…”†–‡–ˆ˜‰˜Š˜‹˜Œ˜Ž  š‘š’š“œ”š•œ–ž—ž˜ž™žš’› œ’ ž’ Ÿ’  ’¡”¢”£”¤”¥¢¦¢§¢¨¢©” ª–«¤¬– ­¤®¤¯¦°¦±¦²– ³¨´¨µ¨¶–·ª¸¬¹œºž»¶¼¨½¨¾ž¿ªÀžÁž ÂªÞ ÄÂŶÆÄÇÄÈÆÉžÊÊËÊÌÌÍžÎÐÏžÐÒÑžÒžÓÞÔÌÕÐÖÒ×ÞØžÙ¢ÚàÛàܤÝàÞàßâà¤áèâêã¤äîåðæêçòèòéôêòëôìöí¤ îôïøð¤ ñøòøóøôúõúöú÷úøüùüúüû¦ü¦ýüþüÿþ¦þªþþ ª    ª    ª¬¬ !" #¬ $ %° & '° (°) * +²,²-²."/² 0² 1"2²3"4"5²6,7´8,9,:´;6<,=6>´?8@:A8B8CEèa!@&N €&B<t€<N €=t€>t=t>t€=v€>N About SHOWÖ€BS€ccount LockingD€COS€DDDATEd€ddition Operator (+)²€DDTIMEf€_MONTHSd€ ES_DECRYPTH€ENCRYPTJ€&ggregate Functions as Window Functions¬€ LTER DATABASE¶€EVENT¨€FUNCTION¨€ LOGFILE GROUPž€ PROCEDUREª€SEQUENCEð€RVERž€TABLEž€ SPACEž €USER€VIEWª€NALYZE FORMAT=JSON8€ Examples8€ Statement:€TABLE|€pplication-Time Periods² €REA€sBinary|€SCIIŽ€IN €ssignment Operator (:=)L €=)r€Text€WKB| €T€TAN €2€uthentication from MariaDB 10.4€ UTO_INCREMENTª€VGX BACKUP LOCKÀ€STAGE€EGIN END¤€NCHMARKH€ TWEEN ANDv€IGINTŽ€NŽ€ARY’€inary Literalsh€INARY OperatorŽ€LOGd € _GTID_POSH€T€itemporal Tables"€IT_ANDZ€COUNTN€LENGTHŽ €OR\€XOR\€LOB’€ and TEXT Data TypesT€OOLEANˆ€oolean Literalsj€OUNDARY†€UFFER\ CACHE INDEXü€LL2€ SE OPERATOR€ Statement¬€T€EIL€ING€NTROID€HANGE MASTER TO´€R’€ BYTET€Function€SETf€_LENGTH’€ ECK TABLE~€VIEWR€ SUM TABLE|€R’€LOSE\ €OALESCEv€ ERCIBILITYf€LLATIONH €olumnStore Window Functions¬€ OLUMN_ADD €CHECK° €REATE €DELETE° €EXISTS°€GET €JSON €LIST²€ omment Syntax2€OMMIT€PRESSJ€NCAT’€_WS”€oncurrent Inserts(€ ONNECTION_IDJ€STRAINTâ€TAINSj €V€ERT”€_TZh€XHULL\€S€T€UNT\€ DISTINCT^€RC32€C€ EATE DATABASEÄ€EVENTÆ€FUNCTIONž€ UDF„€INDEXÊ€PACKAGEÊ€ BODYÌ€ROCEDUREž€ROLE@€SEQUENCEî€ RVERЀTABLEž € SPACEž€RIGGERÒ€USER€VIEWž€reating User-Defined Functions†€ROSSESj €UME_DIST €RDATEj€ RENT_DATEr €ROLEh€TIMEr € STAMPr€USERh€ursor Overview¶€URTIMEt DATABASEh€Ež€ate and Time LiteralsH€Unitsh€ ATE FUNCTIONt €DIFFj€TIME¦€_ADDj€FORMATt€SUBp€Yt€NAMEp€OFMONTHp€WEEKp€YEARt€EALLOCATE / DROP PREPARE8€CIMALŽ€LARE CONDITION¬€ URSOR²€HANDLER®€Variable¬€ODEH€ _HISTOGRAMj€ORACLE€FAULTl€GREES€LETE€ elimitersZ€ ENSE_RANK€SCRIBED€_DECRYPTJ€ENCRYPTJ€IMENSION†€SJOINTl€V€ivision Operator (/),€Oh €UBLE€ ROP DATABASEÌ€EVENTЀFUNCTIONÒ€  UDF‚€INDEXÞ€PACKAGEž€  BODY¢€ROCEDUREà€ROLE>€SEQUENCEê€RVERà€TABLE€ SPACE¤€RIGGERà€USER"€VIEWà€UALh€ynamic Columns¤€ from MariaDB 10èELT”€NCODEL€RYPTL€DPOINT€UM”€VELOPE†€QUALSl€XCEPT€ECUTE IMMEDIATE8€ Statement8€P€LAINh€ ANALYZEh€ FORMAT=JSON8€ORT_SET–€ xtended ShowØ€riorRing€XTRACTr€VALUE–FETCH\€IELD˜€ ND_IN_SET˜€ RST_VALUE €LOAT€loating-point Accuracy€LOOR€USHb€ QUERY CACHEb €TABLES FOR EXPORTÈ€OR®€ UPDATE€MAT˜€ _PICO_TIMEr€UND_ROWSh€ ROM_BASE64˜€DAYSt€UNIXTIMEv1Generated (Virtual and Persistent/Stored) Columnsž€omCollFromText€ WKB€€etry Hierarchy†€ Typesˆ€EOMETRYCOLLECTION\€eometryCollectionFromText€WKB€€FromText € WKB€€N† €Type† €FromText"€WKB€ € ET_FORMATv€LOCKP€LENGTH€OTOX €RANT€EATESTL €OUP BY€_CONCAT^HANDLER Commands4€for MEMORY Tables4€ ELP Commandü€_DATE€VERSION€X˜€exadecimal LiteralsD€IGH_PRIORITY and LOW_PRIORITY,€OURrIdentifier Case-sensitivityD€ NamesF€ QualifiersH€ to File Name MappingJ€FZ€ Function€NULL€GNORE €Nx€ET4–€6T€_ATONN€NTOAR€_ATON €NTOA"€SERT&€ - Default & Duplicate Values,€DELAYED(€Functionš€IGNORE,€ON DUPLICATE KEY UPDATE.€SELECT € ...RETURNING0€ TALL PLUGIN€SONAME €R€TŒ€ nteriorRingN €NTERSECT€ Sl€VALx€nvisible ColumnsÞ€Sx€ NOTx€ NULLL€ULLz€sClosed†€Empty†€SNULLN€sRing†€Simple†€ S_FREE_LOCK" €IPV4R€_COMPATR€MAPPEDR€6" € USED_LOCK>€TERATE° JOIN Syntax€ SON Data Type–€Path Expressionsö€_ARRAY¤ € AGGò€ _APPENDô€ INSERTø€COMPACT¤ €NTAINSø€ _PATHø€DEPTHø€TAILEDú€EQUALSú€XISTSú€TRACTú€INSERTü€KEYSü€LENGTHü€OOSE¦€MERGE¦€ _PATCHü€ RESERVEü€ NORMALIZEþ€OBJECT¦€ AGGô€VERLAPSþ€PRETTYª€QUERYþ€OTEþ€REMOVE€PLACE€ SCHEMA_VALID€EARCH€Tª€TABLE€YPE€UNQUOTE€VALID€UEKILL [CONNECTION | QUERY]þLabels°€AG€ST_DAYv€ INSERT_IDn€VALUEp€CASE €EAD €STz€VE°€FT €NGTHš€Bš€IKEœ€MIT€ ineFromText$€WKB€ € INESTRING´€ineStringFromText&€WKB€€N€OAD DATA INFILEh €INDEXd€XML"€_FILEŒ€CALTIMEv€ STAMPv €TEš€K IN SHARE MODEf€TABLES €G €10 €2 €NGBLOBV€TEXT–€OPZ€WERœ€PADž€TRIMžMAKEDATEx€TIMEx€_SETž€STER_GTID_WAITT€POS_WAITR€ TCH AGAINSTž€X^€ BR Definition€Contains€Disjoint€Equal € Intersects€Overlaps€Touches€Within€D5€edian Window Function € EDIUMBLOBT €INTŒ€TEXTT €RGEê€etadata Locking€ ICROSECONDx€icroseconds in MariaDBf€ID’€N`€UTEv € LineFromText(€ WKB| €OD €odulo Operator (%)´€ONTHv€NAMEx€ PointFromText*€ WKB~€ lyFromText€ WKB~€ULTILINESTRING`€ultiLineStringFromText€WKB€€plication Operator (*),€ ULTIPOINT`€ultiPointFromText€WKB€€ ULTIPOLYGON¶€ultiPolygonFromText€WKB€mysql.func Table‚ NAME_CONST>€TURAL_SORT_KEY €EXT VALUE for sequence_nameò€.on-Recursive Common Table Expressions Overview€ OT BETWEENz€ot Equal Operatorr€UMPOINTS€OVERLAPSr€ PointFromText €OINTN € ONSURFACEb€ olyFromText€ gonFromText€ STARTPOINT€ YMDIFFERENCE¸€TOUCHESd€UNION¸€WITHINd€X€Y €ubqueries and ALL€NY€EXISTS€JOINs€ in a FROM Clause€ y Limitations€UMb€ YSTEM_USERL€_GUID@Table Value ConstructorsZ€AN €EXTž€IME¤€STAMPX€NYBLOBV€INT„€TEXTV€OUCHESr€ransaction Timeouts € RUE FALSER €NCATE  UNCOMPRESSH€INSTALL PLUGIN € SONAME€ON€ LOCK TABLES€PDATE€ SE [DATABASE]€seful MariaDB Queriesh€SERn€ser Password ExpiryD€$-Defined Functions Calling Sequencesˆ€Security‚€ VariablesZ€2ing Compound Statements Outside of Stored Programs¢€UIDV€ Data Type¢€_SHORTXVALUES / VALUEX€RBINARY–€CHAR €IANCEd€_POPd€SAMPf€ERSIONpWAIT and NOWAIT"€HILEZ €ITH €INd€ KT DefinitionX €A Transactions€ORDY€ EAR Data Type ^N|P€Â"X›UNOT LIKE’€REGEXPŽ€Wx€TH_VALUEª€ILE€ULLIF €umeric Data Type OverviewŠ€LiteralsL€ Geometries†€ InteriorRings €Points€VL €2OCT€ ET_LENGTH € LD_PASSWORDL€PEN\€perator Precedence"€ PTIMIZE TABLE€€ptimizer Hints€RD’ €ER BY€VERLAPSn Parenthesesz€ASSWORDL€ERCENTILE_CONT€ DISC€_RANK€IOD_ADDz€DIFFz€I€lugin Overview€OINT`€ ointFromText € WKB€€N € OnSurface` € lyFromText €WKB€€OLYGON¶€olygonFromText€ WKB€€OSITION’ €W€ER €%recedence Control in Table Operations€REPARE Statement:€VIOUS VALUE FOR sequence_nameò€OCEDUREf €  ANALYSEj€URGE BINARY LOGSüQUARTERx €OTE’RADIANS €ND €OM_BYTESN€K€*ecursive Common Table Expressions Overview"€EGEXPŒ€_INSTRŽ€REPLACEŽ€SUBSTRŽ€LEASE_ALL_LOCKST€LOCKV€ NAME TABLE¶€USER"€ PAIR TABLE~€VIEW€€ EAT Function”€LOOP°€LACE€ Function”€ ...RETURNING0€ eserved Wordsj€ESETþ€ MASTER´€ REPLICA/SLAVE6€IGNAL²€TURNZ€VERSE”€OKE"€IGHT”€ oles OverviewB€OLLBACK€UND €Wœ€ ow Subqueries€OWNUMr€_COUNTl€NUMBER€PAD¢€TRIM¢ SAVEPOINT€calar Subqueries€CHEMAJ €ECONDx €_TO_TIMEz€LECT € ... OFFSET ... FETCH€INTO°€ DUMPFILE€ OUTFILE€ WITH ROLLUP$€equence Overview¤€ ESSION_USERJ €TÒ€ CHARACTER SETЀ Data TypeV € EFAULT ROLE@€NAMESÔ€PASSWORD>€ROLE@€ SQL_LOG_BINd€TATEMENTÔ€ TRANSACTION€VariableÖ€VALô€FORMAT¢€HA1N€2N€ OW AUTHORSÚ€ BINARY LOGSÖ€ LOG EVENTSÖ€ CHARACTER SETØ€LIENT_STATISTICSÜ€OLLATION€UMNS¼€ NTRIBUTORSÜ€REATE DATABASEÜ€ EVENTÞ€ FUNCTIONÞ€ PACKAGEÞ€ BODYÞ€ ROCEDUREà€ SEQUENCEà€ TABLEº€ RIGGERà€ USERº€ VIEW†DATABASESâ€ENGINEä€  INNODB STATUSæ€ Sâ€RRORSä€VENTSè€XPLAINÀ€ FUNCTION CODEf€STATUSè€GRANTS¸€INDEX¾€LOCALESè€ MASTER STATUSÈ€ OPEN TABLESè€PACKAGE BODY STATUSê€ STATUSê€LUGINSЀ  SONAMEЀ RIVILEGESì€ OCEDURE CODEê€STATUSê€ SSLISTî€FILEð€ Sd€QUERY_RESPONSE_TIMEd €RELAYLOG EVENTSÈ€ SLAVE HOSTSÈ€ STATUSd€TATUSò€ TABLE STATUSô€ Sò€ _STATISTICSö€RIGGERSö€USER_STATISTICSö€ VARIABLESø€WARNINGSú€SREP_MEMBERSHIPú€ STATUSú€UTDOWN€IGN €AL´€N €LEEP>€MALLINTŠ€OUNDEX¢€S LIKE” €PACE–€ TIAL INDEXŠ€IDER_BG_DIRECT_SQL€ COPY_TABLES€ DIRECT_SQL €FLUSH_TABLE_MON_CACHE¬ €QL_MODE=ORACLEj€RT €RID†€ TART SLAVE6€ TRANSACTION€POINT€D`€DEVb€_POPb€SAMPD€OP SLAVE,€tored Aggregate FunctionsZ€TRCMP¤€tring LiteralsL€ TR_TO_DATEx€_AREA€sBinary€€GeoJSON²€Text€WKB‚€SWKT€BOUNDARYŠ€UFFER¸€CENTROID€ONTAINSb€VEXHULL¸€ROSSESb€ DIFFERENCEn€MENSIONŠ€SJOINTb€TANCEn€ _SPHEREp€ENDPOINT€VELOPEŠ€QUALSb€ xteriorRing€GeomCollFromText€WKB†€etryCollectionFromText€WKB‚€ FromText€WKB‚ €EOMETRYN†€ TYPEˆ€eomFromGeoJSON"€ Text€ WKB‚ € InteriorRingN€ NTERSECTION` € Sb€SCLOSEDŒ€EMPTYˆ€sRingŠ€SimpleŒ€LENGTHp€ ineFromText€ WKB‚€StringFromText€WKB‚€ NUMGEOMETRIESŒ€umInteriorRings€UMPOINTS€OVERLAPSr€ PointFromText € WKB„€OINTN € ONSURFACEb€ olyFromText€ WKB„€ gonFromText€WKB†€RELATEŒ€SRIDŒ € TARTPOINT€ YMDIFFERENCE¸€TOUCHESd€UNION¸€WITHINd€X€Y €UBDATEz€ubqueries and ALL€NY€EXISTS€JOINs€ in a FROM Clause€ y Limitations€UBSTR– €ING¤€ _INDEX¤€TIME~€ubtraction Operator (-),€UMb€YSDATE~€ystem-Versioned Tables² € YSTEM_USERL€_GUID@Table Value ConstructorsZ€AN €EXTž€IME¤€ Functionx€DIFF~€STAMPX€ FUNCTION~€ ADD€€ DIFF€€_FORMATz €TO_SEC€€NYBLOBV€INT„€TEXTV€OUCHESr€_BASE64¦€CHAR¦€DAYS€€SECONDS‚€ransaction Timeouts €RIM¦€UE FALSER €NCATE € TABLEÄ€ype Conversion¬UCASE– € NCOMPRESSH€ ED_LENGTH¨€HEX¨€INSTALL PLUGIN € SONAME€ON€ X_TIMESTAMP‚€ LOCK TABLES€PDATE€XML¨€PER–€ SE [DATABASE]€seful MariaDB Queriesh€SERn€ser Password ExpiryD€$-Defined Functions Calling Sequencesˆ€Security‚€ VariablesZ€2ing Compound Statements Outside of Stored Programs¢€TC_DATE|€TIME|€STAMP‚€UIDV€ Data Type¢€_SHORTXVALUES / VALUEX€RBINARY–€CHAR €IANCEd€_POPd€SAMPf€ERSIONpWAIT and NOWAIT"€EEK„€DAY„€OFYEAR„€ IGHT_STRINGª€ell-Known Binary (WKB) Format†€HILEZ € indow Frames€unctions Overviewª€ITH €INd€ KT Definition€SREP_LAST_SEEN_GTID²€ WRITTEN_GTID²€SYNC_WAIT_UPTO_GTID"X €A Transactions€ORDY€EAR†€ Data Type €WEEK†^N_rowidœ|P€|X~R CŒrNOT INzì¼™