Ejemplo 1: mysql booleano
-- MySQL doesn't have a boolean. Instead, use TINYINT. BOOL and BOOLEAN
-- are aliases to TINYINT. 0 is true, while 1 is false for TINYINT.
-- You can also use TRUE, FALSE, true, false, True, or false as
-- aliases for 0 and 1 respectively.
CREATE TABLE IF NOT EXISTS boolTest (
thisFieldIsTrue TINYINT DEFAULT 0 -- True by default
thisFieldIsFalse TINYINT DEFAULT 1 -- False by default
thisIsAlsoTru BOOL DEFAULT True -- True by default, see above for alternates to True and Bool
)
Ejemplo 2: mysql booleano
SELECT true, false, TRUE, FALSE, True, False;
-- 1 0 1 0 1 0
¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)