MySQL TINYINT(1) versus BIT(1)

Question

Please enlighten me...

Which data type consumes the smallest, TINYINT(1) or BIT(1)?

I know that TINYINT(1) and BIT(1) is considered the same according to majority of answers here.

Doesn't TINYINT(1) accepts 0-9 while BIT(1) can only 1 or 0. From the looks of it TINYINT uses larger storage because it can accept 2-9 while BIT only 1 and 0.

http://stackoverflow.com/questions/290223/what-is-the-difference-between-bit-and-tinyint-in-mysql — Danny Kopping, May 01 '15 at 15:07

Krycke · Accepted Answer · 2015-05-02T05:32:42.617

4

A TINYINT will always have a size of one (1) byte. And accept values between -128 and 127 (if signed).

The number you put in the brackets is for display purposes.

A BIT(1) on the other hand only take one bit in storage but needs to be aligned to whole bytes, meaning that if you only have one BIT(1) column, one byte is used, but if you have multiple they can be placed in the same byte.

edited May 02 '15 at 05:32

answered May 01 '15 at 15:20

Krycke

3,106
1
17
21

according to http://stackoverflow.com/questions/25428842/bit1-or-tinyint-for-flags-in-mysql BIT(1) takes-up 1 byte? – gptimajo May 02 '15 at 01:30

MySQL TINYINT(1) versus BIT(1)

1 Answers1