Zitat von kaminbausatz
Beitrag anzeigen
Code:
mysql> CREATE TEMPORARY TABLE typeof AS SELECT TRUE AS bool_true, FALSE AS bool_false; Query OK, 1 row affected (0.02 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> SELECT * FROM typeof; +-----------+------------+ | bool_true | bool_false | +-----------+------------+ | 1 | 0 | +-----------+------------+ 1 row in set (0.00 sec) mysql> DESCRIBE typeof; +------------+--------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------+------+-----+---------+-------+ | bool_true | int(1) | NO | | 0 | | | bool_false | int(1) | NO | | 0 | | +------------+--------+------+-----+---------+-------+ 2 rows in set (0.00 sec)
Kommentar