You are viewing the archived documentation of TiDB, which no longer receives updates.

View latest LTS version docs

Control Flow Functions

z
y
T
s

TiDB supports all of the control flow functions available in MySQL 5.7.

NameDescription
CASECase operator
IF()If/else construct
IFNULL()Null if/else construct
NULLIF()Return NULL if expr1 = expr2