how to determine constant values in mysql
Related FAQs
- how to find which tables use innodb in mysql
- How to search a tablename in schema
- How to get the students who are in more than one group mysql
- How to find the duplicate rows by comparing two columns in a table mysql
- How to get the length of a string in a column mysql
- How to get the records posted in this month in mysql
- how to find duplicate rows in a table based on specific column
- how to determine constant values in mysql
- how to concatenate all rows of a particular column in a table mysql
- How to connect the mysql from command prompt
The constants TRUE and FALSE
Wed, 06/30/2010 - 16:28 — bandariThe constants TRUE and FALSE evaluate to 1 and 0, respectively. The constant names can be written in any lettercase.
eg: SELECT TRUE, true, FALSE, false;
o/p
TRUE TRUE FALSE FALSE
1 1 0 0