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

Question

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

score 21 · Answer 1 · edited May 23 '17 at 10:29

21

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

I think you need tinyint(1).

edited May 23 '17 at 10:29

Community

answered Feb 21 '12 at 17:52

Widor

score 7 · Answer 2 · answered Dec 21 '12 at 16:38

7

Skip the workbench and use the command line

alter table my_table add column my_column BOOLEAN;

answered Dec 21 '12 at 16:38

1

I just did this and the DataType was changed to TINYINT(1). – Old Geezer Feb 11 '17 at 09:04

score 0 · Answer 3 · answered Sep 06 '12 at 10:44

0

To Create a Boolean Column in Table with default false

ALTER TABLE table_name ADD field_name tinyint(1);

if default true

ALTER TABLE table_name ADD field_name tinyint(0);

answered Sep 06 '12 at 10:44

Rakesh

3

Rakesh your answer is not correct (or is partially correct), the value in parentheses isn't the default value, and do not affect the data type at all. It's called "Data-wise", or display size and it is merely a display width hint. https://dba.stackexchange.com/a/55062 – tecla Apr 25 '20 at 03:41

3 Answers3