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. Elt
  9. Field
  10. Lcase
  11. Left
  12. Length
  13. Lower
  14. Lpad
  15. Repeat
  16. Replace
  17. Reverse
  18. Right
  19. Rpad
  20. Upper

Numeric Functions

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

Thank You for Visiting Our Blog