MySQL Tutorial Control Flow Functions 22 codes

  1. Home
  2. MySQL Tutorial
  3. Control Flow Functions
1 A number can also be returned from IF() function
2 A SUM() function can be added to CASE statement to give us the total
3 CASE with case-sensitve comparison
4 CASE with condition
5 CASE with value
6 Control Flow Functions
7 Create a table based on the result of IFNULL
8 IF(expr1,expr2,expr3)
9 IFNULL() with NULL and NOT NULL value
10 IFNULL(expr1,expr2)
11 NULLIF(expr1,expr2)
12 Use and IF() and COUNT() to give us a total as COUNT() ignores NULL values
13 Use IF with data in a table
14 Use the IFNULL() function to specify a zero in place of the NULL figure
15 Using CASE to switch the employee id
16 Using IF in where clause
17 Using IF with float point value
18 Using IF() function to compare numbers
19 Using IFNULL in where clause
20 Using IFNULL with data in a table
21 Using NULLIF with data in a table
22 Using string comparison function with IF