circle-info
Webinar | The Great Database Exodus: Navigating Strategic Risk in the Post-Oracle MySQL Era
Watch Nowarrow-up-right
LogoLogo
search
⌘Ctrlk
Download MariaDBContact Us
  • Home
  • MariaDB Platform
  • Server
  • MaxScale
  • Analytics
  • Galera Cluster
  • Connectors
  • Tools
  • MariaDB Cloud
  • Release Notes
  • General Resources
GitBook Assistant
GitBook Assistant
Working...Thinking...
GitBook Assistant
Good evening

I'm here to help you with the docs.

⌘Ctrli
AI Based on your contextquestion-circle
LogoLogo
  • serverMariaDB Server Documentation
  • rabbit-runningQuickstart Guides
  • tvServer Usage
  • gearServer Management
  • shield-halvedSecurity
  • house-blankArchitecture
  • wrenchClients & Utilities
  • chart-mixedHA & Performance
  • paperclipReference
    • SQL Structure
    • SQL Statements
    • SQL Functions
      • Functions & Operators
      • Aggregate Functions
      • Control Flow Functions
      • Date & Time Functions
      • Numeric Functions
      • Pseudo Columns
      • Secondary Functions
        • Bit Functions and Operators
        • Encryption, Hashing and Compression Functions
        • Information Functions
          • BENCHMARK
          • BINLOG_GTID_POS
          • CHARSET
          • COERCIBILITY
          • COLLATION
          • CONNECTION_ID
          • CURRENT_ROLE
          • CURRENT_USER
          • DATABASE
          • DECODE_HISTOGRAM
          • DEFAULT
          • FOUND_ROWS
          • LAST_INSERT_ID
          • LAST_VALUE
          • PROCEDURE ANALYSE
          • ROW_COUNT
          • ROWNUM
          • SCHEMA
          • SESSION_USER
          • SYSTEM_USER
          • USER
          • VERSION
        • Miscellaneous Functions
      • Special Functions
      • String Functions
      • Vector Functions
    • Data Types
    • Plugins
    • System Tables
    • Error Codes
    • Client/Server Protocol
    • Product Development
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. paperclipReferencechevron-right
  2. SQL Functionschevron-right
  3. Secondary Functions

Information Functions

Retrieve system and session metadata. This section details functions to access database names, user details, version info, and query statistics like row counts.

BENCHMARKchevron-rightBINLOG_GTID_POSchevron-rightCHARSETchevron-rightCOERCIBILITYchevron-rightCOLLATIONchevron-rightCONNECTION_IDchevron-rightCURRENT_ROLEchevron-rightCURRENT_USERchevron-rightDATABASEchevron-rightDECODE_HISTOGRAMchevron-rightDEFAULTchevron-rightFOUND_ROWSchevron-rightLAST_INSERT_IDchevron-rightLAST_VALUEchevron-rightPROCEDURE ANALYSEchevron-rightROW_COUNTchevron-rightROWNUMchevron-rightSCHEMAchevron-rightSESSION_USERchevron-rightSYSTEM_USERchevron-rightUSERchevron-rightVERSIONchevron-right
PreviousUNCOMPRESSED_LENGTHchevron-leftNextBENCHMARKchevron-right

Last updated 7 months ago

Was this helpful?

LogoLogo

Products

  • Enterprise Platform
  • Community Server
  • Download MariaDB
  • Pricing

Support

  • Customer Login
  • Technical Support
  • Remote DBA
  • Professional Services

Resources

  • MariaDB Blog
  • Webinars
  • Customer Stories
  • MariaDB Events
  • Documentation
  • Developer Hub

Company

  • About MariaDB
  • Newsroom
  • Leadership
  • MariaDB Careers
  • Legal
  • Privacy Policy

© 2026 MariaDB. All rights reserved.

Was this helpful?