Re: Insert into com Condição IF

[laptop alias]

SELECT * FROM users;
+---------+-------+-------+-------+
| usersID | name  | flag1 | flag2 |
+---------+-------+-------+-------+
|       1 | harry |     0 |     0 |
|       2 | bill  |     0 |     0 |
+---------+-------+-------+-------+

INSERT INTO users SELECT 3,'jorge',CASE WHEN 1=1 THEN 0 ELSE 1 END,1;

SELECT * FROM users;
+---------+-------+-------+-------+
| usersID | name  | flag1 | flag2 |
+---------+-------+-------+-------+
|       1 | harry |     0 |     0 |
|       2 | bill  |     0 |     0 |
|       3 | jorge |     0 |     1 |
+---------+-------+-------+-------+