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)
