david@intel-compute-stick:/var/www/html/028$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 1299
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 TABLE menge002;
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> CREATE DATABSE menge002;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DATABSE menge002' at line 1
MariaDB [(none)]> CREATE DATABASE menge002;
Query OK, 1 row affected (0.001 sec)
MariaDB [(none)]> USE menge002;
Database changed
MariaDB [menge002]> CREATE TABLE a (x VARCHAR (4));
Query OK, 0 rows affected (0.055 sec)
MariaDB [menge002]> CREATE TABLE b (x VARCHAR (4));
Query OK, 0 rows affected (0.058 sec)
MariaDB [menge002]> CREATE TABLE c (x VARCHAR (4));
Query OK, 0 rows affected (0.067 sec)
MariaDB [menge002]> SELECT * FROM a;
+------+
| x |
+------+
| 5 |
| 9 |
| 2 |
| 7 |
| 12 |
| 11 |
| 0 |
| 5 |
| 7 |
| 10 |
| 8 |
| 11 |
| 1 |
| 6 |
| 5 |
| 0 |
| 13 |
| 6 |
| 12 |
| 8 |
+------+
20 rows in set (0.001 sec)
MariaDB [menge002]> SELECT x FROM (SELECT x FROM a UNION SELECT x FROM b)x ORDER BY x;
+------+
| x |
+------+
| 0 |
| 1 |
| 10 |
| 11 |
| 12 |
| 13 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
+------+
14 rows in set (0.003 sec)
MariaDB [menge002]> SELECT x FROM (SELECT x FROM a UNION SELECT x FROM c)x ORDER BY x;
+------+
| x |
+------+
| 0 |
| 1 |
| 10 |
| 11 |
| 12 |
| 13 |
| 2 |
| 3 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
+------+
13 rows in set (0.003 sec)
MariaDB [menge002]> SELECT x FROM (SELECT x FROM b UNION SELECT x FROM c)x ORDER BY x;
+------+
| x |
+------+
| 0 |
| 1 |
| 10 |
| 12 |
| 13 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
+------+
13 rows in set (0.003 sec)
MariaDB [menge002]> SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM b)x ORDER BY x;
+------+
| x |
+------+
| 0 |
| 10 |
| 12 |
| 13 |
| 2 |
| 5 |
| 6 |
| 9 |
+------+
8 rows in set (0.003 sec)
MariaDB [menge002]> SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM c)x ORDER BY x;
+------+
| x |
+------+
| 1 |
| 10 |
| 12 |
| 13 |
| 2 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
+------+
10 rows in set (0.003 sec)
MariaDB [menge002]> SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM c)x ORDER BY x;
+------+
| x |
+------+
| 10 |
| 12 |
| 13 |
| 2 |
| 3 |
| 5 |
| 6 |
| 9 |
+------+
8 rows in set (0.003 sec)
MariaDB [menge002]> SELECT x FROM (
-> SELECT x FROM c
-> INTERSECT
-> SELECT x FROM (SELECT x FROM a UNION SELECT x FROM b)x
-> )x ORDER BY x;
+------+
| x |
+------+
| 1 |
| 10 |
| 12 |
| 13 |
| 2 |
| 3 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
+------+
11 rows in set (0.004 sec)
MariaDB [menge002]> 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 |
+------+
| 1 |
| 10 |
| 12 |
| 13 |
| 2 |
| 3 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
+------+
11 rows in set (0.005 sec)
MariaDB [menge002]> SELECT x FROM (
-> SELECT x FROM b
-> INTERSECT
-> SELECT x FROM (SELECT x FROM a UNION SELECT x FROM c)x
-> )x ORDER BY x;
+------+
| x |
+------+
| 0 |
| 10 |
| 12 |
| 13 |
| 2 |
| 3 |
| 5 |
| 6 |
| 9 |
+------+
9 rows in set (0.004 sec)
MariaDB [menge002]> 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 |
| 10 |
| 12 |
| 13 |
| 2 |
| 3 |
| 5 |
| 6 |
| 9 |
+------+
9 rows in set (0.005 sec)
MariaDB [menge002]> 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 |
| 12 |
| 13 |
| 2 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
+------+
11 rows in set (0.004 sec)
MariaDB [menge002]> 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 |
| 12 |
| 13 |
| 2 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
+------+
11 rows in set (0.005 sec)
MariaDB [menge002]>
