mhpreiman
1/31/2018 - 1:31 AM

databases

Database Testing: How to Regression Test a Relational Database

  • Use 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).
    Also boolean datatype in mysql is synonymous for tinyint(1) which it unfortunately also shows as. And tinyint takes less space (i think).

JOINS

INNER   mutual results

LEFT     mutual + all left-side

RIGHT  mutual + all right-side

FULL     all rows:

AB
UNION  all distinct rows:
A
B