Tutorial Gateway

MySQL Tutorial

  1. How to Download MySQL
  2. Install MySQL on Windows
  3. Create Database
  4. Drop Database
  5. Create Table
  6. Select Statement
  7. Where Clause
  8. Alias Names
  9. Order By Clause
  10. Insert Statement
  11. Select Distinct Statement

Operators

  1. AND
  2. NOT
  3. OR
  4. XOR

MySQL Joins

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

Aggregate Functions

  1. AVG
  2. BIT_AND
  3. BIT_OR
  4. BIT_XOR
  5. MAX
  6. MIN
  7. STD
  8. STDDEV
  9. STDDEV_POP
  10. STDDEV_SAMP
  11. SUM
  12. VAR_POP
  13. VAR_SAMP
  14. Variance

String Functions

  1. ASCII
  2. Bin
  3. Bit_Length
  4. Char
  5. Char_Length
  6. Character_Length
  7. Concat
  8. Concat_Ws
  9. Elt
  10. Field
  11. Instr
  12. Lcase
  13. Left
  14. Length
  15. Lower
  16. Lpad
  17. Substr
  18. Substring
  19. Repeat
  20. Replace
  21. Reverse
  22. Right
  23. Rpad
  24. Space
  25. Upper

Numeric Functions

  1. ABS
  2. ACOS
  3. ASIN
  4. ATAN
  5. CEILING
  6. COS
  7. COT
  8. DEGREES
  9. FLOOR
  10. LN
  11. POWER
  12. RADIANS
  13. ROUND
  14. SIGN
  15. SIN
  16. SQRT
  17. TAN
  18. TRUNCATE

Thank You for Visiting Our Blog