通过视图查看MySQL Tinybit（1）列

https://www.db-fiddle.com/f/igDh3aJEXRLZEkL7eNrcnc/0

CREATE FUNCTION get_tinyint(MY_BOOLEAN tinyint) RETURNS TINYINT(1) RETURN COALESCE(MY_BOOLEAN, 0);CREATE OR REPLACe VIEW TEST_VIEW ASSELECT     T1.ID AS ID,    get_tinyint(T2.MY_BOOLEAN) AS MY_BOOLEANFROM    TEST1 T1 LEFT JOIN TEST2 T2 ON T1.ID=T2.TEST1_ID;