| |  Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 109 | 109 |
HELP_DATE |
9 |
This help information was generated from the MySQL... |
|
|
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 190 | 190 |
HELP_VERSION |
9 |
This help information was generated from the MySQL... |
|
|
| | Ubah | Salin | Hapus 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/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 90 | 90 |
ABS |
4 |
Syntax:
ABS(X)
Returns the absolute value of X.
... |
MariaDB> SELECT ABS(2);
-> 2
MariaDB> SELE...
|
https://mariadb.com/kb/en/abs/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 446 | 446 |
ACOS |
4 |
Syntax:
ACOS(X)
Returns the arc cosine of X, that... |
MariaDB> SELECT ACOS(1);
-> 0
MariaDB> SEL...
|
https://mariadb.com/kb/en/acos/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 231 | 231 |
ADDDATE |
31 |
Syntax:
ADDDATE(date,INTERVAL expr unit), ADDDATE(... |
MariaDB> SELECT ADDDATE('2008-01-02', 31);
...
|
https://mariadb.com/kb/en/adddate/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 444 | 444 |
+ |
4 |
Syntax:
+
Addition:
URL: https://mariadb.com/kb/... |
MariaDB> SELECT 3+5;
-> 8
|
https://mariadb.com/kb/en/addition-operator/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 59 | 59 |
ADDTIME |
31 |
Syntax:
ADDTIME(expr1,expr2)
ADDTIME() adds expr2... |
MariaDB> SELECT ADDTIME('2007-12-31 23:59:59.99999...
|
https://mariadb.com/kb/en/addtime/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 497 | 497 |
AES_DECRYPT |
12 |
Syntax:
AES_DECRYPT(crypt_str,key_str)
This funct... |
|
https://mariadb.com/kb/en/aes_decrypt/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 443 | 443 |
AES_ENCRYPT |
12 |
Syntax:
AES_ENCRYPT(str,key_str)
AES_ENCRYPT() an... |
INSERT INTO t VALUES (1,AES_ENCRYPT('text','passwo...
|
https://mariadb.com/kb/en/aes_encrypt/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 212 | 212 |
ALTER DATABASE |
39 |
Syntax:
ALTER {DATABASE | SCHEMA} [db_name]
al... |
|
https://mariadb.com/kb/en/alter-database/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 406 | 406 |
ALTER EVENT |
39 |
Syntax:
ALTER
[DEFINER = { user | CURRENT_USER... |
|
https://mariadb.com/kb/en/alter-event/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 233 | 233 |
ALTER FUNCTION |
39 |
Syntax:
ALTER FUNCTION func_name [characteristic .... |
|
https://mariadb.com/kb/en/alter-function/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 226 | 226 |
ALTER LOGFILE GROUP |
39 |
Syntax:
ALTER LOGFILE GROUP logfile_group
ADD ... |
|
https://mariadb.com/kb/en/alter-logfile-group/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 439 | 439 |
ALTER PROCEDURE |
39 |
Syntax:
ALTER PROCEDURE proc_name [characteristic ... |
|
https://mariadb.com/kb/en/alter-procedure/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 373 | 373 |
ALTER SERVER |
39 |
Syntax:
ALTER SERVER server_name
OPTIONS (opt... |
ALTER SERVER s OPTIONS (USER 'sally');
|
https://mariadb.com/kb/en/alter-server/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 463 | 463 |
ALTER TABLE |
39 |
Syntax:
ALTER [ONLINE | OFFLINE] [IGNORE] TABLE tb... |
|
https://mariadb.com/kb/en/alter-table/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 478 | 478 |
ALTER TABLESPACE |
39 |
Syntax:
ALTER TABLESPACE tablespace_name
{ADD|... |
|
https://mariadb.com/kb/en/alter-tablespace/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 159 | 159 |
ALTER VIEW |
39 |
Syntax:
ALTER
[ALGORITHM = {UNDEFINED | MERGE ... |
|
https://mariadb.com/kb/en/alter-view/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 470 | 470 |
ANALYZE TABLE |
20 |
Syntax:
ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE... |
|
https://mariadb.com/kb/en/analyze-table/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 316 | 316 |
&& |
15 |
Syntax:
AND, &&
Logical AND. Evaluates to 1 if al... |
MariaDB> SELECT 1 && 1;
-> 1
MariaDB> SELE...
|
https://mariadb.com/kb/en/and/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 325 | 325 |
AREA |
2 |
Area(poly)
Returns as a double-precision number t... |
MariaDB> SET @poly = 'Polygon((0 0,0 3,3 0,0 0),(1...
|
https://mariadb.com/kb/en/area/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 292 | 292 |
ASBINARY |
32 |
AsBinary(g), AsWKB(g)
Converts a value in interna... |
SELECT AsBinary(g) FROM geom;
|
https://mariadb.com/kb/en/asbinary/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 220 | 220 |
ASCII |
37 |
Syntax:
ASCII(str)
Returns the numeric value of t... |
MariaDB> SELECT ASCII('2');
-> 50
MariaDB>...
|
https://mariadb.com/kb/en/ascii/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 165 | 165 |
ASIN |
4 |
Syntax:
ASIN(X)
Returns the arc sine of X, that i... |
MariaDB> SELECT ASIN(0.2);
-> 0.2013579207...
|
https://mariadb.com/kb/en/asin/ |
