| |  Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 312 | 312 |
! |
15 |
Syntax:
NOT, !
Logical NOT. Evaluates to 1 if the... |
MariaDB> SELECT NOT 10;
-> 0
MariaDB> SELE...
|
https://mariadb.com/kb/en/not/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 495 | 495 |
!= |
18 |
Syntax:
<>, !=
Not equal:
URL: https://mariadb.c... |
MariaDB> SELECT '.01' <> '0.01';
-> 1
Mari...
|
https://mariadb.com/kb/en/not-equal/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 174 | 174 |
% |
4 |
Syntax:
N % M, N MOD M
Modulo operation. Returns ... |
|
https://mariadb.com/kb/en/modulo-operator/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 227 | 227 |
& |
19 |
Syntax:
&
Bitwise AND:
URL: https://mariadb.com/... |
MariaDB> SELECT 29 & 15;
-> 13
|
https://mariadb.com/kb/en/bitwise_and/ |
| | 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` = 98 | 98 |
* |
4 |
Syntax:
*
Multiplication:
URL: https://mariadb.c... |
MariaDB> SELECT 3*5;
-> 15
MariaDB> SELECT...
|
https://mariadb.com/kb/en/multiplication-operator/ |
| | 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` = 245 | 245 |
- BINARY |
4 |
Syntax:
-
Subtraction:
URL: https://mariadb.com/... |
MariaDB> SELECT 3-5;
-> -2
|
https://mariadb.com/kb/en/subtraction-operator-/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 259 | 259 |
- UNARY |
4 |
Syntax:
-
Unary minus. This operator changes the ... |
MariaDB> SELECT - 2;
-> -2
|
https://mariadb.com/kb/en/subtraction-operator-/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 268 | 268 |
/ |
4 |
Syntax:
/
Division:
URL: https://mariadb.com/kb/... |
MariaDB> SELECT 3/5;
-> 0.60
|
https://mariadb.com/kb/en/division-operator/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 217 | 217 |
< |
18 |
Syntax:
<
Less than:
URL: https://mariadb.com/kb... |
MariaDB> SELECT 2 < 2;
-> 0
|
https://mariadb.com/kb/en/less-than/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 214 | 214 |
<< |
19 |
Syntax:
<<
Shifts a longlong (BIGINT) number to t... |
MariaDB> SELECT 1 << 2;
-> 4
|
https://mariadb.com/kb/en/shift-left/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 81 | 81 |
<= |
18 |
Syntax:
<=
Less than or equal:
URL: https://mari... |
MariaDB> SELECT 0.1 <= 2;
-> 1
|
https://mariadb.com/kb/en/less-than-or-equal/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 117 | 117 |
<=> |
18 |
Syntax:
<=>
NULL-safe equal. This operator perfor... |
MariaDB> SELECT 1 <=> 1, NULL <=> NULL, 1 <=> NULL...
|
https://mariadb.com/kb/en/null-safe-equal/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 71 | 71 |
= |
18 |
=
Equal:
URL: https://mariadb.com/kb/en/equal/
|
MariaDB> SELECT 1 = 0;
-> 0
MariaDB> SELEC...
|
https://mariadb.com/kb/en/equal/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 469 | 469 |
> |
18 |
Syntax:
>
Greater than:
URL: https://mariadb.com... |
MariaDB> SELECT 2 > 2;
-> 0
|
https://mariadb.com/kb/en/greater-than/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 283 | 283 |
>= |
18 |
Syntax:
>=
Greater than or equal:
URL: https://m... |
MariaDB> SELECT 2 >= 2;
-> 1
|
https://mariadb.com/kb/en/greater-than-or-equal/ |
| | Ubah | Salin | Hapus DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 382 | 382 |
>> |
19 |
Syntax:
>>
Shifts a longlong (BIGINT) number to t... |
MariaDB> SELECT 4 >> 2;
-> 1
|
https://mariadb.com/kb/en/shift-right/ |
| | 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` = 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/ |
