MySQL Functions (Advanced)

Profile picture for user arilio666
Submitted by arilio666 on
  1. BIN: This function returns representation in binary of a number
  2. BINARY: This function converts a value to a binary string
  3. CASE: This function goes through conditions and returns a value when the first condition is met
  4. CAST: This function converts a value (of any type) into a specified datatype
  5. COALESCE: This function returns  first non-null value in a list
  6. CONNECTION_ID: This function returns the unique connection ID for the current connection
  7. CONV: This function converts a number from one numeric base system to another
  8. CONVERT: This function converts a value into the specified datatype or character set
  9. CURRENT_USER: This function returns the user name and hostname for the MySQL account that the server used to authenticate the current client
  10. DATABASE: This function returns the name of  current database.
  11. IF: This function returns a value if a condition is a TRUE or another value if a condition is FALSE
  12. IFNULL: This function returns a specified value if the expression is NULL. Otherwise, return the expression
  13. ISNULL: This function returns 1 or 0 depending on whether an expression is NULL
  14. LAST_INSERT_ID: This function returns the AUTO_INCREMENT id of the last row that has been inserted or updated in a table
  15. NULLIF: This function compares two expressions and returns NULL if they are equal. Otherwise, the first expression is returned
  16. SESSION_USER: This function returns MySQL user name which currently appear and hostname
  17. SYSTEM_USER: This function returns the current MySQL user name and hostname
  18. USER: This function returns the current MySQL user name and hostname
  19. VERSION: This function returns the current version of the MySQL database
Related Content
MySQL Tutorial
MySQL: Average Function
MySQL: Numeric Functions List
Tags
MySQL