1
2
3
4
5
6
7
8
9
10
11
|
CREATE TABLE t1 (A BOOL, B VARCHAR(5));
SHOW CREATE TABLE t1;
INSERT INTO t1 VALUES (0, FALSE);
INSERT INTO t1 VALUES (1, TRUE);
INSERT INTO t1 VALUES (TRUE, TRUE);
INSERT INTO t1 VALUES (FALSE, FALSE);
--sorted_result
SELECT A,B FROM t1;
DROP TABLE t1;
|