This example illustrates how create a boolean data type.
This example illustrates how create a 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 | | | | +-------+---------------+------+-----+---------+-------+
|