Database Testing: How to Regression Test a Relational Database
tinyint(1)
for boolean values (sometimes bit
is 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).boolean
datatype in mysql is synonymous for tinyint(1)
which it unfortunately also shows as. And tinyint
takes less space (i think).INNER mutual results
LEFT mutual + all left-side
RIGHT mutual + all right-side
FULL all rows:
A | B |
A |
B |