Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Stack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
Explore Stack Internal I can understand that if you updateUPDATE a tinyint(1)TINYINT(1) column in a database and pass a value of 11 or 00 it will convert it to trueTRUE or falseFALSE, respectively.
I'm just confused on what happens when you updateUPDATE the column with a different numbervalue, say 22. In other words, if you updateUPDATE a tinyint(1)TINYINT(1) column with the value 22, will this be trueTRUE or falseFALSE? Or, is this even doable?
I can understand that if you update a tinyint(1) column in a database and pass a value of 1 or 0 it will convert it to true or false, respectively. I'm just confused on what happens when you update the column with a different number, say 2. In other words, if you update a tinyint(1) column with the value 2, will this be true or false? Or is this even doable?
I can understand that if you UPDATE a TINYINT(1) column and pass a value of 1 or 0 it will convert it to TRUE or FALSE, respectively.
I'm just confused on what happens when you UPDATE the column with a different value, say 2. In other words, if you UPDATE a TINYINT(1) column with the value 2, will this be TRUE or FALSE? Or, is this even doable?
I can understand that if you update a tinyint(1) column in a database and pass a value of 1 or 0 it will convert it to true or false, respectively. I'm just confused on what happens when you update the column with a different number, say 2. In other words, if you update a tinyint(1) column with the value 2, will this be true or false? Or is this even doable?
