How can i create boolean column and assign value 1 when creating/altering a column of a mysql table?

Question

I'm trying something like this =>

alter table tablename modify columnname "boolean" default 1 NOT NULL;

Which is the correct format to create boolean column ?

Solution 1

ALTER TABLE tablename CHANGE columnname columnname BOOLEAN DEFAULT '1' NOT NULL

Is this what you are after?

Solution 2

alter table tablename modify columnname boolean default true NOT NULL;

Don't put quotes around boolean.

I tested this on a column that was int and it worked.

Comments

[shibly]

boolean default true and boolean default 1 , are they same ?

[shibly]

modify columnname and change columnname , are they similar ?

[shibly]

What is prefered in MyISM database engine ?

[Johan]

Nonsense, boolean is tinyint(1), there is no difference.

[Bohemian]

modify alters just the column datatype. change alters the column datatype and also renames the column (not needed here).