Entering Boolean Values in MySQL

Q

How To Enter Boolean Values in SQL Statements in MySQL?

✍: FYIcenter.com

A

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 |
+------+------+-------+-------+

 

⇒Introduction to SQL Basics in MySQL

⇒⇒MySQL Database Tutorials

2018-03-31, 317👍, 0💬

General MySQL Oracle SQL Server