Andy Andy - 1 year ago 198
MySQL Question

phpmyadmin won't change MySQL TINYINT(1) to BOOLEAN data type

I'm running MySQL 5.5.47 and have a number of database tables that have columns with a data type of

. I'm attempting to change these to
but it won't change them.

Using phpmyadmin 4.6.0 then going to Structure I'm using the dropdown to set the columns to
. This executes the following query:

ALTER TABLE `feedback` CHANGE `tick_receive_updates` `tick_receive_updates` BOOLEAN NOT NULL;

The query runs successfully.

When I view the Structure it does not update: the columns are still marked as being

At first I thought this was a phpmyadmin bug so I ran

DESCRIBE feedback;

Unfortunately the problem remains - columns have not changed from

Why is this?

Answer Source

This is normal behavior as BOOLEAN is just a synonym of TINYINT(1)

MySQL 5.7 Reference Manual - 12.1.1 Numeric Type Overview


These types are synonyms for TINYINT(1). A value of zero is considered false. Nonzero values are considered true:

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download