MySQL Boolean Data Type

For boolean fields, we could use a column of type TINYINT(1) which stores values of either ‘0’ or ‘1’.

For such columns, MySQL allows queries with values true or false and will convert internally into 0 or 1 within the database.