MySQL Boolean Value


 

MySQL Boolean Value

This example illustrates how to find the boolean type status of the table.

This example illustrates how to find the boolean type status of the table.

MySQL Boolean Value

This example illustrates how to find the boolean type status of the table.

In this example execute a query 'SHOW TABLE STATUS LIKE "%bool%"', it display the boolean type status of the field which is display below in the table.

Query

SHOW TABLE STATUS LIKE "%bool%";

Output

+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-------
----+----------------+---------------------+-------------+------------+-----------+----------+----------------+-------
---------------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_f
ree | Auto_increment | Create_time         | Update_time | Check_time | Collation | Checksum | Create_options | Commen
t              |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-------
----+----------------+---------------------+-------------+------------+-----------+----------+----------------+-------
---------------+
| bool | InnoDB | 10      | Compact    | 0    | 0              | 16384       | 0               | 0            | 0
    | 1              | 2009-01-20 13:06:29 |             |            | binary    | NULL     |                | InnoDB
 free: 3072 kB |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-------
----+----------------+---------------------+-------------+------------+-----------+----------+----------------+-------
---------------+
1 row in set (0.02 sec)

Ads