Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 22
22
CREATE TRIGGER
39
Syntax:
CREATE
[DEFINER = { user | CURRENT_USE...
https://mariadb.com/kb/en/create-trigger/
Editar
Copiar
Borrar
DELETE 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/
Editar
Copiar
Borrar
DELETE 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/