Generate mysql truth table

test.php

<?php

use Symfony\Component\Process\Process;

require 'vendor/autoload.php';

$comparisons = ['AND', 'OR'];
$expressions = ['NULL', '0', '1'];

$sql = [];

foreach ($comparisons as $comparison) {
    foreach ($expressions as $x) {
        foreach ($expressions as $y) {

            $_sql = <<<'EOT'
            SELECT '%1$s' x, '%2$s' op, '%3$s' y, (%1$s %2$s %3$s) result
            EOT;

            $sql[] = sprintf($_sql, $x, $comparison, $y);
        }
    }
}

$sql = implode(' UNION ALL ', $sql).';';

$proc = new Process(['mysql', '--table', '-e', $sql]);
$proc->mustRun();

echo $proc->getOutput();