-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSQL injection techniques
102 lines (51 loc) · 2.7 KB
/
SQL injection techniques
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
1. UNION SELECT - combines two SELECT statements into one
2. SELECT * FROM - selects all data from a table
3. ORDER BY - sorts data in a table
4. WHERE - filters data in a table
5. INSERT INTO - inserts data into a table
6. UPDATE - modifies data in a table
7. DELETE FROM - deletes data from a table
8. DROP TABLE - deletes a table
9. ALTER TABLE - modifies a table structure
10. CREATE TABLE - creates a new table
11. CREATE USER - creates a new user
12. GRANT - grants permissions to a user
13. REVOKE - revokes permissions from a user
14. LIKE - searches for a specific pattern in a table
15. IN - filters data based on a list of values
16. BETWEEN - filters data based on a range of values
17. EXISTS - checks if a subquery returns any rows
18. COUNT - counts the number of rows in a table
19. SUM - calculates the sum of values in a column
20. AVG - calculates the average of values in a column
21. MAX - returns the maximum value in a column
22. MIN - returns the minimum value in a column
23. HAVING - filters data based on a condition applied to a group of rows
24. GROUP BY - groups rows based on a specific column
25. DISTINCT - removes duplicate rows from a result set
26. JOIN - combines two or more tables into one
27. INNER JOIN - returns only the rows that match between two tables
28. LEFT JOIN - returns all the rows from the left table and the matched rows from the right table
29. RIGHT JOIN - returns all the rows from the right table and the matched rows from the left table
30. FULL OUTER JOIN - returns all the rows from both tables, matching the rows where possible
31. CROSS JOIN - returns the Cartesian product of two tables
32. NATURAL JOIN - matches columns with the same name in two tables
33. GROUP_CONCAT - concatenates rows into a single string
34. INTO OUTFILE - exports data to a file on the server
35. LOAD DATA INFILE - imports data from a file on the server
36. CASE - applies conditional logic to a query
37. IF - applies conditional logic to a query
38. CAST - converts data from one data type to another
39. SUBSTRING - extracts a substring from a string
40. CONCAT - concatenates two or more strings
41. REPLACE - replaces a substring in a string
42. CHAR - converts a number to a character
43. DATE - converts a date to a string
44. NOW - returns the current date and time
45. UNIX_TIMESTAMP - returns the current Unix timestamp
46. RAND - generates a random number
47. SLEEP - delays the execution of a query
48. UUID - generates a unique identifier
49. SHA1 - calculates the SHA1 hash of a string
50. MD5 - calculates the MD5 hash of a string
Again, I must remind you that using SQL injection techniques without proper authorization and consent is illegal and unethical