Code: Alles auswählen
<?php
include ("/home/david/db_settings.php");
$db = new PDO ("mysql: host=localhost", $MYSQL_USER, $MYSQL_PASSWORD);
$sql = "CREATE DATABASE q0001" . $rnd = (rand () % 8192);
$db->query ($sql);
$sql = "USE q0001" . $rnd;
$db->query ($sql);
$sql = "CREATE TABLE a (x INTEGER); CREATE TABLE b (x INTEGER); CREATE TABLE c (x INTEGER)";
$db->query ($sql);
for ($i = 0; $i < 32; $i++) {
$sql = "INSERT INTO a (x) VALUES (" . rand () % 32 . "); ";
$sql .= "INSERT INTO b (x) VALUES (" . rand () % 64 . "); ";
$sql .= "INSERT INTO c (x) VALues (" . rand () % 128 . "); ";
$db->query ($sql);
}
$sql = "SELECT x FROM (SELECT x FROM a UNION SELECT x FROM b) x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " ";
echo "<br><br>\n\n";
$sql = "SELECT x FROM (SELECT x FROM a UNION SELECT x FROM c) x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " ";
echo "<br><br>\n\n";
$sql = "SELECT x FROM (SELECT x FROM b UNION SELECT x FROM c) x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " ";
echo "<br><br>\n\n";
$sql = "SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM b) x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " ";
echo "<br><br>\n\n";
$sql = "SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM c) x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " ";
echo "<br><br>\n\n";
$sql = "SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM c) x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " ";
echo "<br><br>\n\n";
$sql = "SELECT x FROM (
SELECT x FROM (SELECT x FROM a UNION SELECT x FROM b) x
INTERSECT
SELECT x FROM c
) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " ";
echo "<br><br>\n\n";
$sql = "SELECT x FROM (
SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM c) x
UNION
SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM c) x
) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " ";
echo "<br><br>\n\n";
$sql = "SELECT x FROM (
SELECT x FROM (SELECT x FROM a UNION SELECT x FROM c) x
INTERSECT
SELECT x FROM b
) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " ";
echo "<br><br>\n\n";
$sql = "SELECT x FROM (
SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM b) x
UNION
SELECT x FROM (SELECT x FROM c INTERSECT SELECT x FROM b) x
) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " ";
echo "<br><br>\n\n";
$sql = "SELECT x FROM (
SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM a) x
UNION
SELECT x FROM (SELECT x FROM c INTERSECT SELECT x FROM a) x
) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " ";
echo "<br><br>\n\n";
$sql = "SELECT x FROM (
SELECT x FROM (SELECT x FROM b UNION SELECT x FROM c) x
INTERSECT
SELECT x FROM a
) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " ";
echo "<br><br>\n\n";
$db = null;
?>
Code: Alles auswählen
20 31 24 22 25 0 13 15 6 30 28 26 5 7 18 1 19 12 11 27 55 17 45 50 23 60 44 42 9 46 62 8 3 36 54 39 34 <br><br>
20 31 24 22 25 0 13 15 6 30 28 26 5 7 18 1 19 12 11 27 34 48 119 96 97 29 122 63 65 104 99 105 92 118 81 107 60 125 16 82 17 62 56 108 68 54 109 <br><br>
55 17 12 24 45 50 23 60 30 44 42 9 5 46 62 0 27 8 15 3 36 6 28 54 39 34 48 119 96 97 29 122 63 65 104 99 105 92 118 81 107 125 16 82 56 108 68 109 <br><br>
24 0 15 6 30 28 5 12 27 <br><br>
30 <br><br>
17 60 30 62 54 34 <br><br>
17 30 34 54 60 62 <br><br>
17 30 34 54 60 62 <br><br>
0 5 6 12 15 17 24 27 28 30 34 54 60 62 <br><br>
0 5 6 12 15 17 24 27 28 30 34 54 60 62 <br><br>
0 5 6 12 15 24 27 28 30 <br><br>
0 5 6 12 15 24 27 28 30 <br><br>