What is the difference betwen TINYINT(1) and Boolean in MySQL?

Question

In MySQL, what is the difference betwen TINYINT(1) and Boolean?

Community · Accepted Answer · 2020-06-20 09:12:55Z

4

From the manual:

BOOL, BOOLEAN

These types are synonyms for TINYINT(1).

There is no difference.

11 silver badge

answered Jul 18, 2012 at 21:50

844k202 gold badges1.6k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

@Justin Niessner: if only every SO member read the documentation - amount of questions would decrease to at least an order of magnitude

Right, it's easy to say "read the manual" AFTER you already know the answer and where it is in said manual.

@Jonathan Allen: "mysql boolean" google request 1st result is the referred page

zerkms · Accepted Answer · 2012-07-18 21:50:53Z

2

There is no. BOOLEAN is an alias to TINYINT(1)

answered Jul 18, 2012 at 21:50

256k73 gold badges447 silver badges551 bronze badges

Mike Brant · Accepted Answer · 2012-07-18 21:52:03Z

0

BOOL or BOOLEAN and just synonyms for TINYINT(1)

answered Jul 18, 2012 at 21:52

71.4k10 gold badges102 silver badges104 bronze badges