View Column as Boolean

Asked Mar 14 '17 at 18:32

Active Mar 14 '17 at 18:32

Viewed 141 times

I'm trying to create a view with a column type as boolean or tinyint(1), but I'm not sure how to customize the datatype. Previously this question was answered by saying, use cast() or convert(). I can't do that here as mysql doesn't allow boolean as an output type.

I've also tried using

if(`mytable`.`mycolumn`=1,TRUE,FALSE) AS myAlias

Unfortunately myAlias in the view is created as a bigint(20)

Here's the similar question I was talking about where casting was suggested. My reputation isn't high enough for me to post a comment there, so I decided to make a separate question. Is it possible to change the datatype of a column in a view?

Thanks

edited May 23 '17 at 12:32

Community

asked Mar 14 '17 at 18:32

Max Power

When I try this, `desc viewname;` says the type is `int(1)`. – Barmar Mar 14 '17 at 18:39
You can also use `select mytable.mycolumn = 1 as myAlias` – Barmar Mar 14 '17 at 18:40

View Column as Boolean

0 Answers0