Answers

Question and Answer:

  Home  MySQL Programming

⟩ How To Enter Boolean Values in SQL Statements?

If you want to enter Boolean values in SQL statements, you use (TRUE), (FALSE), (true), or (false). Here are some good examples:

SELECT TRUE, true, FALSE, false FROM DUAL;

+------+------+-------+-------+

| TRUE | TRUE | FALSE | FALSE |

+------+------+-------+-------+

| 1 | 1 | 0 | 0 |

+------+------+-------+-------+

 148 views

More Questions for you: