2.2.1. Operatoren und Funktionen

Data Retrieval Language

Operatoren und Funktionen (Auszug)

Art kann gefiltert werden nach: Arithmetisch, Vergleichs, String, Date, System, Aggregat

Kategorie kann gefiltert werden nach: Funktion, Operator

id	art	kategorie	name	beschreibung
id	art	kategorie	name	beschreibung
1	Arithmetisch	Operator	+	Plus operator
2	Arithmetisch	Operator	–	Minus operator
3	Arithmetisch	Operator	*	Mutiplication operator
4	Arithmetisch	Operator	/	Division operator
5	Arithmetisch	Operator	DIV	Integer Division
6	Arithmetisch	Operator	%	Modulo operator
7	Arithmetisch	Operator	MOD	Modulo operator
11	Arithmetisch	Funktion	ABS()	Absolute value
12	Arithmetisch	Funktion	ACOS()	Arc cosine
13	Arithmetisch	Funktion	ASIN()	Arc sine
14	Arithmetisch	Funktion	ATAN()	Arc tangent
15	Arithmetisch	Funktion	ATAN2()	Arc tangent
16	Arithmetisch	Funktion	CEIL()	Smallest integer value not less than the argument
17	Arithmetisch	Funktion	CEILING()	Smallest integer value not less than the argument
18	Arithmetisch	Funktion	CONV()	Convert numbers between different number bases
19	Arithmetisch	Funktion	COS()	Cosine
20	Arithmetisch	Funktion	COT()	Cotangent
21	Arithmetisch	Funktion	CRC32()	Compute a cyclic redundancy check value
22	Arithmetisch	Funktion	DEGREES()	Convert radians to degrees
23	Arithmetisch	Funktion	EXP()	Raise the power of
24	Arithmetisch	Funktion	FLOOR()	Largest integer value not greater than the argument
25	Arithmetisch	Funktion	LN()	Natural logarithm
26	Arithmetisch	Funktion	LOG10()	Base-10 logarithm
27	Arithmetisch	Funktion	LOG2()	Base-2 logarithm
28	Arithmetisch	Funktion	LOG()	Natural logarithm
29	Arithmetisch	Funktion	MOD()	Remainder
30	Arithmetisch	Funktion	PI()	Pi
31	Arithmetisch	Funktion	POW()	Argument raised to specified power
32	Arithmetisch	Funktion	POWER()	Argument raised to specified power
33	Arithmetisch	Funktion	RADIANS()	Convert degrees to radians
34	Arithmetisch	Funktion	RAND()	random floating point value
35	Arithmetisch	Funktion	ROUND()	round the argument
36	Arithmetisch	Funktion	SIGN()	Sign of the argument
37	Arithmetisch	Funktion	SIN()	Sine
38	Arithmetisch	Funktion	SQRT()	Square root of the argument
39	Arithmetisch	Funktion	TAN()	Tangent
40	Arithmetisch	Funktion	TRUNCATE()	Truncate to specified number of decimal places
51	Vergleichs	Funktion	COALESCE()	Returns the first non-NULL argument
52	Vergleichs	Funktion	GREATEST()	Returns the largest argument
53	Vergleichs	Funktion	IN()	Check whether a value is within a set of values
54	Vergleichs	Funktion	INTERVAL()	Return the index of the argument that is less than the first argument
55	Vergleichs	Funktion	ISNULL()	Test whether the argument is NULL or not
56	Vergleichs	Funktion	LEAST()	Returns the smallest argument
57	Vergleichs	Funktion	NOT IN()	Check whether a value is not within a set of values
58	Vergleichs	Funktion	STRCMP()	Compare two strings
61	Vergleichs	Operator	BETWEEN … AND	Check whether a value is within a range of values
62	Vergleichs	Operator	NOT BETWEEN … AND	Check whether a value is not within a range of values
63	Vergleichs	Operator		NULL-safe equal to
64	Vergleichs	Operator	=	Equal
65	Vergleichs	Operator	!=	Not equal
66	Vergleichs	Operator		Not equal
67	Vergleichs	Operator	>=	Greater than or equal
68	Vergleichs	Operator	<=	Less than or equal
69	Vergleichs	Operator	<	Less than
70	Vergleichs	Operator	>	Greater than
71	Vergleichs	Operator	IS NULL	NULL value test
72	Vergleichs	Operator	IS NOT NULL	Not NULL value test
73	Vergleichs	Operator	IS	Test a value against a boolean
74	Vergleichs	Operator	IS NOT	Test a value against a boolean
75	Vergleichs	Operator	LIKE	Simple pattern matching
76	Vergleichs	Operator	NOT LIKE	Negation of simple pattern matching
81	String	Funktion	CHAR()	Returns the character for each integer past
82	String	Funktion	CHARACTER_LENGTH()	Synonym for CHAR_LENGTH()
83	String	Funktion	CHAR_LENGTH()	Returns number of characters in argument
84	String	Funktion	CONCAT()	Returns the concatenated string
85	String	Funktion	INSERT()	Insert a substring at the specified position up to the specified number of characters
86	String	Funktion	INSTR()	Returns the index of the first occurence of substring
87	String	Funktion	LCASE()	Synony for LOWER()
88	String	Funktion	LEFT()	Returns the leftmost number of characters as specified
89	String	Funktion	LENGTH()	Returns the length of a string in bytes
90	String	Funktion	LOCATE()	Returns the position of the first occurence of a substring
91	String	Funktion	LOWER()	Returns the argument in lowercase
92	String	Funktion	LPAD()	Returns the string, leftpadded with the specified string
93	String	Funktion	LTRIM()	Removes leading spaces
94	String	Funktion	MATCH()	Perform full text search
95	String	Funktion	REPEAT()	Repeat a string the specified number of times
96	String	Funktion	REPLACE()	Replace occurences of a specified string
97	String	Funktion	REVERSE()	Reverse the characters of a string
98	String	Funktion	RIGHT()	Returns the rightmost number of characters as specified
99	String	Funktion	RLIKE()	Synonym for REGEXP
100	String	Funktion	RPAD()	Append string the specified number of times
101	String	Funktion	RTRIM()	Removes trailing spaces
102	String	Funktion	SOUNDEX()	Return a soundex string
103	String	Funktion	SOUNDS LIKE()	Compare sounds
104	String	Funktion	SUBSTR()	Return the substring as specified
105	String	Funktion	TRIM()	Remove leading and trailing spaces
106	String	Funktion	UCASE()	Synonym for UPPER()
107	String	Funktion	UPPER()	Convert to uppercase
111	Date	Funktion	ADDDATE()	Add time value (intervals) to a date value
112	Date	Funktion	ADDTIME()	Add time
113	Date	Funktion	CURDATE()	Return current date
114	Date	Funktion	CURRENT_DATE	Synonym for CURDATE()
115	Date	Funktion	CURRENT_DATE()	Synonym for CURDATE()
116	Date	Funktion	CURTIME()	Return current time
117	Date	Funktion	CURRENT_TIME	Synonym for CURTIME()
118	Date	Funktion	CURRENT_TIME()	Synonym for CURTIME()
119	Date	Funktion	CURRENT_TIMESTAMP	Synonym for NOW()
120	Date	Funktion	CURRENT_TIMESTAMP()	Synonym for NOW()
121	Date	Funktion	DATE()	Extract the date part of a date or datetime expression
122	Date	Funktion	DATEDIFF()	Subtracts two dates
123	Date	Funktion	DAY()	Synonym for DAYOFMONTH()
124	Date	Funktion	DAYNAME()	Return the name of the weekday
125	Date	Funktion	DAYOFMONTH()	Return the day of the month (0-31)
126	Date	Funktion	DAYOFWEEK()	Return the weekday index of the argument (0-6)
127	Date	Funktion	DAYOFYEAR()	Return the day of the year (1-366)
128	Date	Funktion	HOUR()	Return the hour
129	Date	Funktion	LAST_DAY()	Return the last day of the month for the argument
130	Date	Funktion	LOCALTIME	Synonym for NOW()
131	Date	Funktion	LOCALTIME()	Synonym for NOW()
132	Date	Funktion	LOCALTIMESTAMP	Synonym for NOW()
133	Date	Funktion	LOCALTIMESTAMP()	Synonym for NOW()
134	Date	Funktion	MINUTE()	Return the minute of the argument
135	Date	Funktion	MONTH()	Return the month of the argument
136	Date	Funktion	MONTHNAME()	Return the name of the month
137	Date	Funktion	NOW()	Return the current date and time
138	Date	Funktion	QUARTER()	Return the quarter from a date argument
139	Date	Funktion	SECOND()	Return the second (0-59)
140	Date	Funktion	STR_TO_DATE()	Convert a string to a date
141	Date	Funktion	SYSDATE()	Return the time at which the function executes
142	Date	Funktion	TIME()	Extract the time portion of the expression passed
143	Date	Funktion	TIMEDIFF()	Subtract two given times
144	Date	Funktion	TIMESTAMP()	With a single argument this function returns the date or datetime expression with two arguments, the sum of the arguments
145	Date	Funktion	TO_DAYS()	Return the date argument converted to days
146	Date	Funktion	WEEK()	Return the week number
147	Date	Funktion	WEEKDAY()	Return the weekday index
148	Date	Funktion	WEEKOFYEAR()	Return the calendar week of the year (1-53)
149	Date	Funktion	YEAR()	Return the year
150	Date	Funktion	YEARWEEK()	Return the year and week
171	System	Funktion	BENCHMARK()	Repeatedly execute an expression
172	System	Funktion	CHARSET()	Return the character set of the argument
173	System	Funktion	COERCIBILITY()	Return the collation coecibility of the string argument
174	System	Funktion	COLLATION()	Return the collation of the string argument
175	System	Funktion	CONNECTION_ID()	Return the connection ID (thread ID) of the connection
176	System	Funktion	CURRENT_USER	Return the authenticated username and hostname
177	System	Funktion	CURRENT_USER()	Return the authenticated username and hostname
178	System	Funktion	DATABASE()	Return the current database name
179	System	Funktion	FOUND_ROWS()	For a SELECT with a LIMIT clause, the number of rows that would be returned without LIMIT
180	System	Funktion	LAST_INSERT_ID()	Value of AUTOINCREMENT column for the last INSERT
181	System	Funktion	ROW_COUNT()	The number of rows updated
182	System	Funktion	SCHEMA()	Synonym for DATABASE()
183	System	Funktion	SESSION_USER()	Synonym for USER()
184	System	Funktion	SYSTEM_USER()	Synonym for USER()
185	System	Funktion	USER()	Return the user name and host name
186	System	Funktion	VERSION()	Return a string that indicates the MySQL server version
201	Aggregat	Funktion	AVG()	Return the average value of the argument
202	Aggregat	Funktion	BIT_AND()	Return bitwise and
203	Aggregat	Funktion	BIT_OR()	Return bitwise or
204	Aggregat	Funktion	BIT_XOR()	Return bitwise xor
205	Aggregat	Funktion	COUNT(DISTINCT)	Return the count of a number of different values
206	Aggregat	Funktion	COUNT()	Return a count the number of rows returned
207	Aggregat	Funktion	GROUP_CONCAT()	Return a concatenated string
208	Aggregat	Funktion	MAX()	Return the maximum value
209	Aggregat	Funktion	MIN()	Return the minimum value
210	Aggregat	Funktion	STD()	Return the standard deviation
211	Aggregat	Funktion	STDDEV_POP()	Return the standard deviation
212	Aggregat	Funktion	STDDEV_SAMP()	Return the sample standard deviation
213	Aggregat	Funktion	STDDEV()	Return the standard deviation
214	Aggregat	Funktion	SUM()	Return the sum
215	Aggregat	Funktion	VAR_POP()	Return the standard variance
216	Aggregat	Funktion	VAR_SAMP()	Return the sample variance
217	Aggregat	Funktion	VARIANCE()	Return the standard variance