· 7 years ago · Feb 12, 2019, 12:26 AM
1CREATE DATABASE my_db;
2USE my_db;
3CREATE TABLE IF NOT EXISTS if_table(
4 id INTEGER unsigned,
5 field_1 INTEGER unsigned,
6 field_2 INTEGER unsigned,
7 field_3 INTEGER unsigned,
8 PRIMARY KEY (id)
9);
10
11if field_2 equals 0 then field_1 = field_1 + 1
12else field_3 = field_3 + 2
13where id == 1
14
15SELECT IF(field_2 = 0, field_1 + 1, field_3 + 2) AS `Result`
16FROM tableName
17WHERE ID = 1
18
19UPDATE tableName
20SET field_1 = IF(field_2 = 0, field_1 + 1, field_1),
21 field_3 = IF(field_2 = 0, field_3, field_3 + 2)
22WHERE ID = 1
23
24UPDATE table_name SET field_1 = field_1 + 1 WHERE id = 1 AND field_2 = 0;
25UPDATE table_name SET field_3 = field_3 + 2 WHERE id = 1 AND field_2 != 0;
26
27UPDATE table_name
28SET field_1 = IF(field_2 = 0, field_1 + 1, field_1),
29SET field_3 = IF(field_2 = 0, field_3, field_3 + 2),
30WHERE ID = 1