Explain different types of MySQL functions?

Posted by Prem Tiwari | Updated on

This is the basic MySQL Interview Questions asked in an interview. Find below the different types of functions used in MySQL.

  1. MySQL String Functions: Examples are- INSERT, CONCAT, FORMAT, INSERT, LENGTH, LEFT, FIELD, LTRIM, TRIM, UPPER etc.
  2. MySQL Numeric Functions: Examples are- AVG, DIV, EXP, MAX, MIN, POWER, TRUNCATE etc.
  3. MySQL Date Functions: Examples are – ADDDATE, ADDTIME, DATE, MONTH, MINUTE etc.
  4. MySQL Advanced Functions: Examples are – BIN, CASE, CAST, DATABASE, IF, ISNULL, VERSION etc.

If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.

Related Questions & Answers