MySQL Tutorial

This MySQL Tutorial explains everything about the Server. This MySQL tutorial section includes Database creation, modification, and deleting databases and tables. DML, DDL statements, Built-in functions etc.

  1. How to Download the MySQL
  2. Install on Windows
  3. Create Database
  4. Drop Database
  5. Create Table
  6. Drop Table
  7. Select Statement
  8. Where Clause
  9. Alias Names
  10. Group By Clause
  11. Having Clause
  12. Order By Clause
  13. Limit
  14. Insert Statement
  15. Delete Command
  16. Select Distinct Statement
  17. Truncate Table

MySQL Tutorial on Operators

Use this section to learn MySQL operators

  1. Arithmetic Operators
  2. AND
  3. NOT
  4. OR
  5. XOR
  6. Between
  7. Not Between
  8. GREATEST
  9. LEAST
  10. LIKE
  11. NOT LIKE
  12. Coalesce
  13. IFNULL
  14. NULLIF
  15. Interval
  16. IN
  17. IS
  18. NOT IN
  19. IS NULL
  20. IS NOT NULL

Learn MySQL Joins

  1. Inner Join
  2. Left Join
  3. Right Join
  4. Cross Join

MySQL Tutorial on Functions

The folding is the MySQL aggregate function. Please refer to the list of available Aggregates.

  1. AVG()
  2. BIT_AND()
  3. BIT_OR()
  4. BIT_XOR()
  5. COUNT()
  6. COUNT(DISTINCT)
  7. GROUP_CONCAT()
  8. MAX()
  9. MIN()
  10. STD()
  11. STDDEV()
  12. STDDEV_POP()
  13. STDDEV_SAMP()
  14. SUM()
  15. VAR_POP()
  16. VAR_SAMP()
  17. VARIANCE()

This section covers the list of MySQL Date Functions to understand everything about these.

  1. ADDDATE()
  2. ADDTIME()
  3. CONVERT_TZ()
  4. CURDATE()
  5. CURRENT_DATE, CURRENT_DATE()
  6. CURRENT_TIME(), CURRENT_TIME
  7. CURRENT_TIMESTAMP() ,CURRENT_TIMESTAMP
  8. CURTIME()
  9. DATE()
  10. DATE_ADD()
  11. DATE_FORMAT()
  12. DATE_SUB()
  13. DATEDIFF()
  14. DAY()
  15. DAYNAME()
  16. DAYOFMONTH()
  17. DAYOFWEEK()
  18. DAYOFYEAR()
  19. EXTRACT()
  20. FROM_DAYS()
  21. FROM_UNIXTIME()
  22. GET_FORMAT()
  23. HOUR()
  24. LAST_DAY
  25. LOCALTIME(), LOCALTIME
  26. LOCALTIMESTAMP(), LOCALTIMESTAMP
  27. MAKEDATE()
  28. MAKETIME()
  29. MICROSECOND()
  30. MINUTE()
  31. MONTH()
  32. MONTHNAME()
  33. NOW()
  34. PERIOD_ADD()
  35. PERIOD_DIFF()
  36. QUARTER()
  37. SEC_TO_TIME()
  38. SECOND()
  39. STR_TO_DATE()
  40. SUBDATE()
  41. SUBTIME()
  42. SYSDATE()
  43. TIME()
  44. TIME_FORMAT()
  45. TIME_TO_SEC()
  46. TIMEDIFF()
  47. TIMESTAMP()
  48. TIMESTAMPADD()
  49. TIMESTAMPDIFF()
  50. TO_DAYS()
  51. TO_SECONDS()
  52. UNIX_TimeStamp
  53. UTC_Date
  54. UTC_Time
  55. UTC_TimeStamp
  56. Week
  57. Weekday
  58. WeekOfYear
  59. Year
  60. YearWeek

Learn about the MySQL String functions that are available. You can use the hyperlink to get the introduction and definitions of each and every one.

  1. ASCII()
  2. BIN()
  3. BIT_LENGTH()
  4. CHAR()
  5. CHAR_LENGTH()
  6. CHARACTER_LENGTH()
  7. CONCAT()
  8. CONCAT_WS()
  9. ELT()
  10. EXPORT_SET()
  11. FILED()
  12. FIND_IN_SET()
  13. FORMAT()
  14. HEX()
  15. INSERT()
  16. INSTR()
  17. LCASE()
  18. LEFT()
  19. LENGTH()
  20. LIKE
  21. LOAD_FILE()
  22. LOCATE()
  23. LOWER()
  24. LPAD()
  25. LTRIM()
  26. MAKE_SET()
  27. MATCH()
  28. MID()
  29. NOT_LIKE
  30. NOT_REGEXP
  31. OCT()
  32. OCTET_LENGTH()
  33. ORD()
  34. POSITION()
  35. QUOTE()
  36. REGEXP
  37. REPEAT()
  38. REPLACE()
  39. REVERSE()
  40. RIGHT()
  41. RLIKE
  42. RPAD()
  43. RTRIM()
  44. SOUNDEX()
  45. SOUNDS LIKE
  46. SPACE()
  47. STRCMP()
  48. SUBSTR()
  49. SUBSTRING()
  50. SUBSTRING_INDEX()
  51. TRIM()
  52. UCASE()
  53. UNHEX()
  54. UPPER()

It explains to you the list of MySQL Mathematical and Trigonometric functions. Use this for numeric calculations.

  1. ABS()
  2. ACOS()
  3. ASIN()
  4. ATAN()
  5. ATAN2()
  6. CEIL()
  7. CEILING()
  8. CONV()
  9. COS()
  10. COT()
  11. CRC32()
  12. DEGREES()
  13. EXP()
  14. FLOOR()
  15. LN()
  16. LOG()
  17. LOG10()
  18. LOG2()
  19. MOD()
  20. PI
  21. POW()
  22. POWER()
  23. RADIANS()
  24. RAND()
  25. ROUND()
  26. SIGN()
  27. SIN()
  28. SQRT()
  29. TAN()
  30. TRUNCATE()