BOOL

Synonym for TINYINT(1). This type is commonly used to represent boolean values, where 0 is considered false and non-zero values are true.

Overview

See TINYINT.

EXAMPLES

CREATE TABLE bool_example (
  example BOOL
) DEFAULT CHARSET=latin1;

SHOW CREATE TABLE bool_example\G

*************************** 1. row ***************************
       Table: bool_example
Create Table: CREATE TABLE `bool_example` (
  `example` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}