tinyint(1)for boolean values (sometimes
bitis used too - it's cleaner for db viewing), but still need to check the length because it can store longer than 1 number (it just shows only one).
booleandatatype in mysql is synonymous for
tinyint(1)which it unfortunately also shows as. And
tinyinttakes less space (i think).
INNER mutual results
LEFT mutual + all left-side
RIGHT mutual + all right-side
FULL all rows: