I must store a flexible in to the database which could contain two values. Each one or zero.
What will be the littlest datatype to keep the information in MySQL?
TINYINT(1) can contain amounts between
You should use bit(1)
BOOL is saved in MySQL as TINYINT which may take 1 full byte
A little(1) would normally also take 1-byte but when you will find multiple bits in one record, they get saved within the same byte, as much as 8 per byte.
Its a perfect situation for any boolean data type