|
|
 编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 161
|
161 |
~ |
19 |
Syntax:
~
Invert all bits.
URL: https://mariadb.... |
MariaDB> SELECT 5 & ~1;
-> 4
|
https://mariadb.com/kb/en/3489/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 141
|
141 |
|| |
15 |
Syntax:
OR, ||
Logical OR. When both operands are... |
MariaDB> SELECT 1 || 1;
-> 1
MariaDB> SELE...
|
https://mariadb.com/kb/en/or/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 410
|
410 |
| |
19 |
Syntax:
|
Bitwise OR:
URL: https://mariadb.com/k... |
MariaDB> SELECT 29 | 15;
-> 31
|
https://mariadb.com/kb/en/bitwise-or/ |
|
|
编辑
|
复制
|
删除
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/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 204
|
204 |
YEARWEEK |
31 |
Syntax:
YEARWEEK(date), YEARWEEK(date,mode)
Retur... |
MariaDB> SELECT YEARWEEK('1987-01-01');
->...
|
https://mariadb.com/kb/en/yearweek/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 287
|
287 |
YEAR DATA TYPE |
22 |
YEAR[(2|4)]
A year in two-digit or four-digit for... |
|
https://mariadb.com/kb/en/year-data-type/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 364
|
364 |
YEAR |
31 |
Syntax:
YEAR(date)
Returns the year for date, in ... |
MariaDB> SELECT YEAR('1987-01-01');
-> 198...
|
https://mariadb.com/kb/en/year/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 400
|
400 |
Y |
11 |
Y(p)
Returns the Y-coordinate value for the Point... |
MariaDB> SELECT Y(POINT(56.7, 53.34));
+----------...
|
https://mariadb.com/kb/en/y/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 197
|
197 |
XOR |
15 |
Syntax:
XOR
Logical XOR. Returns NULL if either o... |
MariaDB> SELECT 1 XOR 1;
-> 0
MariaDB> SEL...
|
https://mariadb.com/kb/en/xor/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 317
|
317 |
X |
11 |
X(p)
Returns the X-coordinate value for the Point... |
MariaDB> SELECT X(POINT(56.7, 53.34));
+----------...
|
https://mariadb.com/kb/en/x/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 247
|
247 |
WKT DEFINITION |
3 |
The Well-Known Text (WKT) representation of Geomet... |
|
https://mariadb.com/kb/en/wkt-definition/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 31
|
31 |
WITHIN |
30 |
Within(g1,g2)
Returns 1 or 0 to indicate whether ... |
|
https://mariadb.com/kb/en/within/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 496
|
496 |
WHILE |
23 |
Syntax:
[begin_label:] WHILE search_condition DO
... |
CREATE PROCEDURE dowhile()
BEGIN
DECLARE v1 INT ...
|
https://mariadb.com/kb/en/while/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 267
|
267 |
WEEKOFYEAR |
31 |
Syntax:
WEEKOFYEAR(date)
Returns the calendar wee... |
MariaDB> SELECT WEEKOFYEAR('2008-02-20');
...
|
https://mariadb.com/kb/en/weekofyear/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 371
|
371 |
WEEKDAY |
31 |
Syntax:
WEEKDAY(date)
Returns the weekday index f... |
MariaDB> SELECT WEEKDAY('2008-02-03 22:23:00');
...
|
https://mariadb.com/kb/en/weekday/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 32
|
32 |
WEEK |
31 |
Syntax:
WEEK(date[,mode])
This function returns t... |
MariaDB> SELECT WEEK('2008-02-20');
-> 7
M...
|
https://mariadb.com/kb/en/week/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 505
|
505 |
VERSION |
17 |
Syntax:
VERSION()
Returns a string that indicates... |
MariaDB> SELECT VERSION();
-> '5.5.29-stan...
|
https://mariadb.com/kb/en/version/ |
|
|
编辑
|
复制
|
删除
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/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 157
|
157 |
VAR_POP |
16 |
Syntax:
VAR_POP(expr)
Returns the population stan... |
|
https://mariadb.com/kb/en/var_pop/ |
|
|
编辑
|
复制
|
删除
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/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 257
|
257 |
VARCHAR |
22 |
[NATIONAL] VARCHAR(M) [CHARACTER SET charset_name]... |
|
https://mariadb.com/kb/en/varchar/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 303
|
303 |
VARBINARY |
22 |
VARBINARY(M)
The VARBINARY type is similar to the... |
|
https://mariadb.com/kb/en/varbinary/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 341
|
341 |
VALUES |
14 |
Syntax:
VALUES(col_name)
In an INSERT ... ON DUPL... |
MariaDB> INSERT INTO table (a,b,c) VALUES (1,2,3),...
|
https://mariadb.com/kb/en/values/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 412
|
412 |
UUID_SHORT |
14 |
Syntax:
UUID_SHORT()
Returns a "short" universal ... |
MariaDB> SELECT UUID_SHORT();
-> 923957838...
|
https://mariadb.com/kb/en/uuid_short/ |
|
|
编辑
|
复制
|
删除
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 44
|
44 |
UUID |
14 |
Syntax:
UUID()
Returns a Universal Unique Identif... |
MariaDB> SELECT UUID();
-> '6ccd780c-baba-...
|
https://mariadb.com/kb/en/uuid/ |
