- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
In MySQL, without having BOOLEAN data type how can we show TRUE and FALSE values?
As we know that there is no BOOLEAN data type in MySQL hence by using TRUE or true, FALSE or false we can enter Boolean values in MySQL statement.
Example
mysql> Select TRUE,FALSE; +------+-------+ | TRUE | FALSE | +------+-------+ | 1 | 0 | +------+-------+ 1 row in set (0.00 sec) mysql> Select true,false; +------+-------+ | TRUE | FALSE | +------+-------+ | 1 | 0 | +------+-------+ 1 row in set (0.00 sec)
- Related Articles
- How can we enter BOOLEAN values in MySQL statement?
- How can I count true and false values in my PHP array?
- How can I update the boolean values in MySQL?
- Can we insert values without mentioning the column name in MySQL?
- Can we insert records in a MySQL table without auto_increment values?
- PHP Boolean Data Type
- How can we change the data type of the column in MySQL table?
- How can we match the values having backslashes, like ‘ab’, from MySQL column?
- How can we amend the declared size of a column’s data type in MySQL?
- Why does MySQL evaluate “TRUE or TRUE and FALSE” to true?
- How to set NA values to TRUE for a Boolean column in an R data frame?
- How can we use MySQL POWER() function with the column’s data values?
- How can we create MySQL stored procedures without ‘BEGIN’ and ‘END’?
- How can we use MySQL SELECT without FROM clause?
- How can we use MySQL SUM() function with HAVING clause?

Advertisements