MySQL Boolean Data Type


 

MySQL Boolean Data Type

This example illustrates how create a boolean data type.

This example illustrates how create a boolean data type.

MySQL Boolean Data Type

This example illustrates how create a boolean data type.

In this example we create a table 't' where define four field that is 'a' which is BOOL type, 'b' which is FLOAT type, 'c' which is LONG VARCHAR type and 'd' which is NUMERIC type. The Complete table display below.

 

Query

 

CREATE TABLE t (a BOOL, b FLOAT8, c LONG VARCHAR, d NUMERIC);

 

Query

 

DESCRIBE t;

 

Output

 

+-------+---------------+------+-----+---------+-------+
| Field | Type          | Null | Key | Default | Extra |
+-------+---------------+------+-----+---------+-------+
| a     | tinyint(1)    | YES  |     |         |       |
| b     | double        | YES  |     |         |       |
| c     | mediumblob    | YES  |     |         |       |
| d     | decimal(10,0) | YES  |     |         |       |
+-------+---------------+------+-----+---------+-------+

 

Ads