[Database]Operators
时间:2022-03-14 01:46
Arithmetic Operators
+,-,×,÷
Comparison Operators
=,<>,!=,>,<,>=,<=
LIKE,BETWEEN,IN,IS NULL
Logical Operators
AND,OR,NOT[IN | LIKE| BETWEEN | NULL]
String Operators
LIKE,||
Operators precendence
parentheses > comparison > AND > OR
() > 比较 > and > or
Arithmetic > Comparison > Logical
Strings comparison
digits < lowercase letters < uppercase letters.