|
|
 Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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 |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
DELETE 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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
|
|
Sửa
|
Chép
|
Xóa bỏ
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/ |
