MySQL Workbench: trying to create a boolean field for a table


I'm trying to create a new column as boolean type, but I can't find it in the list..any help?

5.2.37 and ubuntu 11.10

Best Solution

There is no such thing as a 'boolean' in MySql unfortunately.

I think you need tinyint(1).

This question has more: Which MySQL data type to use for storing boolean values