Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 0
0
MIN
16
Syntax:
MIN([DISTINCT] expr)
Returns the minimum ...
MariaDB> SELECT student_name, MIN(test_score), MAX...
https://mariadb.com/kb/en/min/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 1
1
JOIN
27
MySQL supports the following JOIN syntaxes for the...
SELECT left_tbl.*
FROM left_tbl LEFT JOIN right_...
https://mariadb.com/kb/en/join-syntax/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 2
2
HEX
37
Syntax:
HEX(str), HEX(N)
For a string argument st...
MariaDB> SELECT 0x616263, HEX('abc'), UNHEX(HEX('a...
https://mariadb.com/kb/en/hex/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 3
3
REPLACE
27
Syntax:
REPLACE [LOW_PRIORITY | DELAYED]
[INTO...
https://mariadb.com/kb/en/replace/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 4
4
CONTAINS
30
Contains(g1,g2)
Returns 1 or 0 to indicate whethe...
https://mariadb.com/kb/en/contains/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 5
5
SRID
36
SRID(g)
Returns an integer indicating the Spatial...
MariaDB> SELECT SRID(GeomFromText('LineString(1 1,...
https://mariadb.com/kb/en/srid/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 6
6
CURRENT_TIMESTAMP
31
Syntax:
CURRENT_TIMESTAMP, CURRENT_TIMESTAMP()
CU...
https://mariadb.com/kb/en/current_timestamp/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 7
7
SHOW CONTRIBUTORS
26
Syntax:
SHOW CONTRIBUTORS
The SHOW CONTRIBUTORS s...
https://mariadb.com/kb/en/show-contributors/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 8
8
VARIANCE
16
Syntax:
VARIANCE(expr)
Returns the population sta...
https://mariadb.com/kb/en/variance/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 9
9
DROP SERVER
39
Syntax:
DROP SERVER [ IF EXISTS ] server_name
Dro...
https://mariadb.com/kb/en/drop-server/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 10
10
SHOW AUTHORS
26
Syntax:
SHOW AUTHORS
The SHOW AUTHORS statement d...
https://mariadb.com/kb/en/show-authors/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 11
11
VAR_SAMP
16
Syntax:
VAR_SAMP(expr)
Returns the sample varianc...
https://mariadb.com/kb/en/var_samp/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 12
12
CONCAT
37
Syntax:
CONCAT(str1,str2,...)
Returns the string ...
MariaDB> SELECT CONCAT('My', 'S', 'QL');
-...
https://mariadb.com/kb/en/concat/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 13
13
GEOMETRY HIERARCHY
34
Geometry is the base class. It is an abstract clas...
https://mariadb.com/kb/en/geometry-hierarchy/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 14
14
CHAR FUNCTION
37
Syntax:
CHAR(N,... [USING charset_name])
CHAR() i...
MariaDB> SELECT CHAR(77,121,83,81,'76');
-...
https://mariadb.com/kb/en/char-function/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 15
15
DATETIME
22
DATETIME
A date and time combination. The support...
https://mariadb.com/kb/en/datetime/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 16
16
SHOW CREATE TRIGGER
26
Syntax:
SHOW CREATE TRIGGER trigger_name
This sta...
https://mariadb.com/kb/en/show-create-trigger/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 17
17
SHOW CREATE PROCEDURE
26
Syntax:
SHOW CREATE PROCEDURE proc_name
This stat...
MariaDB> SHOW CREATE PROCEDURE test.simpleproc\G
*...
https://mariadb.com/kb/en/show-create-procedure/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 18
18
OPEN
23
Syntax:
OPEN cursor_name
This statement opens a p...
https://mariadb.com/kb/en/open/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 19
19
INTEGER
22
INTEGER[(M)] [UNSIGNED] [ZEROFILL]
This type is a...
https://mariadb.com/kb/en/sql_language-data_types-int
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 23
23
MONTH
31
Syntax:
MONTH(date)
Returns the month for date, i...
MariaDB> SELECT MONTH('2008-02-03');
-> 2
https://mariadb.com/kb/en/month/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 24
24
TINYINT
22
TINYINT[(M)] [UNSIGNED] [ZEROFILL]
A very small i...
https://mariadb.com/kb/en/tinyint/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 29
29
^
19
Syntax:
^
Bitwise XOR:
URL: https://mariadb.com/...
MariaDB> SELECT 1 ^ 1;
-> 0
MariaDB> SELEC...
https://mariadb.com/kb/en/bitwise-xor/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 20
20
LOWER
37
Syntax:
LOWER(str)
Returns the string str with al...
https://mariadb.com/kb/en/lower/
Bearbeiten Kopieren LöschenDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 21
21
SHOW COLUMNS
26
Syntax:
SHOW [FULL] COLUMNS {FROM | IN} tbl_name [...
https://mariadb.com/kb/en/show-columns/