w3resource

MySQL FUNCTIONS and OPERATORS

FUNCTIONS and OPERATORS

In the following section, we have given a list of FUNCTIONS and OPERATORS in MySQL as anyone can view the FUNCTIONS at a glance and jump immediately to his/her requirement.

MySQL Function & Operators Description
Introduction of MySQL functions and operators Types of MySQL functions and operators.
MySQL Comparison Functions and Operators Some Comparison Functions and Operators are -
MySQL Logical Operators MySQL logical AND operator compares two expressions and returns true if both of the expressions are true.
Some Logical Operators are -
MySQL Control Flow Functions Some Control Flow Functions are -
MySQL String Functions Some String Functions in MySQL are -
MySQL Mathematical Functions Some Mathematical Functions in MySQL are -
MySQL Date and Time Functions MySQL Date and Time Functions are used in various type of date and time operation.
MySQL Encryption and Compression Functions MySQL Encryption and Compression Functions are used to encrypt and decrypt a string.
Some Encryption and Compression Functions in MySQL are -
MySQL Bit Functions Some Bit Functions in MySQL are -
MySQL Information Functions Some Information Functions in MySQL are -
  • BENCHMARK()
  • CHARSET()
  • COERCIBILITY()
  • COLLATION()
  • CONNECTION_ID()
  • CURRENT_USER(), CURRENT_USER
  • DATABASE()
  • FOUND_ROWS()
  • LAST_INSERT_ID()
  • SCHEMA()
  • SESSION_USER()
  • SYSTEM_USER()
  • USER()
  • VERSION()

Previous: VARIANCE()
Next: MySQL Comparison functions and operator BETWEEN AND



Follow us on Facebook and Twitter for latest update.