MySQL Tutorial

This MySQL Tutorial explains everything about MySQL Server which includes Database creation, modification, and delete database and tables. DML, DDL statements, Built-in functions etc.

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. ATAN2
6. CEILING
7. COS
8. COT
9. DEGREES
10. FLOOR
11. LN
12. POWER
13. RADIANS
14. ROUND
15. SIGN
16. SIN
17. SQRT
18. TAN
19. TRUNCATE

Thank You for Visiting Our Blog