I am trying to add a
BOOLEAN column using EDIT TABLE in mysql workbench, but it automatically changes to
TINYINT on applying changes.
How can I get the column to be
You probably want to use the
In Mysql you can't have bool, because in Mysql bool is Tinyint, just that it's converted when you create the table.So you can "create" the bool and you can use it as a boolean, but it's a tinyint.
the bool_field I created as bool and mysql put it as tinyiny(1).
if you want to set it as true or false, in the programming world 1 is true and 0 is false.
You can even make conditionals with 1 and 0, like
code here //and if bool_field is 1, it will be the same as bool_field=true