/media/sda-magnetic/david/Dok-15-2023-11-27/informatik/www-intel-compute-stick-2022-06-13/030/output04.txt

david@intel-compute-stick:/var/www/html/030$ mysql -u root -p    
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1487
Server version: 10.5.12-MariaDB-0+deb11u1 Debian 11

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> CREATE DATABASE menge003
    -> ;
Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> USE menge003;
Database changed
MariaDB [menge003]> CREATE TABLE a (x VARCHAR (4));
Query OK, 0 rows affected (0.048 sec)

MariaDB [menge003]> CREATE TABLE b (x VARHCAR (4));
ERROR 4161 (HY000): Unknown data type: 'VARHCAR'
MariaDB [menge003]> CREATE TABLE b (x VARCHAR (4)); 
Query OK, 0 rows affected (0.054 sec)

MariaDB [menge003]> CREATE TABLE c (x VARCHAR (4));
Query OK, 0 rows affected (0.051 sec)

MariaDB [menge003]> SELECT x FROM a;
+------+
| x    |
+------+
| 6    |
| 5    |
| 8    |
| 2    |
| 1    |
| 0    |
| 5    |
| 14   |
| 10   |
| 13   |
| 4    |
| 0    |
| 5    |
| 3    |
| 3    |
| 0    |
| 4    |
| 2    |
| 5    |
| 8    |
+------+
20 rows in set (0.001 sec)

MariaDB [menge003]> SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM b)x ORDER BY x;
+------+
| x    |
+------+
| 0    |
| 1    |
| 10   |
| 14   |
| 2    |
| 3    |
| 6    |
| 8    |
+------+
8 rows in set (0.003 sec)

MariaDB [menge003]> SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM c)x ORDER BY x;
+------+
| x    |
+------+
| 0    |
| 10   |
| 13   |
| 14   |
| 2    |
| 3    |
| 4    |
| 6    |
| 8    |
+------+
9 rows in set (0.003 sec)

MariaDB [menge003]> SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM c)x ORDER BY x;
+------+
| x    |
+------+
| 0    |
| 10   |
| 11   |
| 12   |
| 14   |
| 2    |
| 3    |
| 6    |
| 8    |
| 9    |
+------+
10 rows in set (0.003 sec)

MariaDB [menge003]> SELECT x FROM (SELECT x FROM a UNION SELECT x FROM b)x ORDER BY x;
+------+
| x    |
+------+
| 0    |
| 1    |
| 10   |
| 11   |
| 12   |
| 13   |
| 14   |
| 2    |
| 3    |
| 4    |
| 5    |
| 6    |
| 7    |
| 8    |
| 9    |
+------+
15 rows in set (0.003 sec)

MariaDB [menge003]> SELECT x FROM (SELECT x FROM a UNION SELECT x FROM c)x ORDER BY x;
+------+
| x    |
+------+
| 0    |
| 1    |
| 10   |
| 11   |
| 12   |
| 13   |
| 14   |
| 2    |
| 3    |
| 4    |
| 5    |
| 6    |
| 8    |
| 9    |
+------+
14 rows in set (0.003 sec)

MariaDB [menge003]> SELECT x FROM (SELECT x FROM b UNION SELECT x FROM c)x ORDER BY x;
+------+
| x    |
+------+
| 0    |
| 1    |
| 10   |
| 11   |
| 12   |
| 13   |
| 14   |
| 2    |
| 3    |
| 4    |
| 6    |
| 7    |
| 8    |
| 9    |
+------+
14 rows in set (0.003 sec)

MariaDB [menge003]> 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;
+------+
| x    |
+------+
| 0    |
| 10   |
| 11   |
| 12   |
| 13   |
| 14   |
| 2    |
| 3    |
| 4    |
| 6    |
| 8    |
| 9    |
+------+
12 rows in set (0.003 sec)

MariaDB [menge003]> 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;
+------+
| x    |
+------+
| 0    |
| 10   |
| 11   |
| 12   |
| 13   |
| 14   |
| 2    |
| 3    |
| 4    |
| 6    |
| 8    |
| 9    |
+------+
12 rows in set (0.005 sec)

MariaDB [menge003]> 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;
+------+
| x    |
+------+
| 0    |
| 1    |
| 10   |
| 11   |
| 12   |
| 14   |
| 2    |
| 3    |
| 6    |
| 8    |
| 9    |
+------+
11 rows in set (0.004 sec)

MariaDB [menge003]> 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;
+------+
| x    |
+------+
| 0    |
| 1    |
| 10   |
| 11   |
| 12   |
| 14   |
| 2    |
| 3    |
| 6    |
| 8    |
| 9    |
+------+
11 rows in set (0.006 sec)

MariaDB [menge003]> 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;
+------+
| x    |
+------+
| 0    |
| 1    |
| 10   |
| 13   |
| 14   |
| 2    |
| 3    |
| 4    |
| 6    |
| 8    |
+------+
10 rows in set (0.004 sec)

MariaDB [menge003]> 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;
+------+
| x    |
+------+
| 0    |
| 1    |
| 10   |
| 13   |
| 14   |
| 2    |
| 3    |
| 4    |
| 6    |
| 8    |
+------+
10 rows in set (0.005 sec)

MariaDB [menge003]> quit
Bye
david@intel-compute-stick:/var/www/html/030$