Forum libero

$ mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 5.5.35-MariaDB-log MariaDB Server

Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.

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

MariaDB [(none)]> CREATE DATABASE testdb;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> USE testdb;
Database changed
MariaDB [testdb]> CREATE TABLE TBL1 (id INT(1) PRIMARY KEY) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.01 sec)

MariaDB [testdb]> CREATE TABLE TBL2 (id2 INT(1) REFERENCES TBL1 (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.01 sec)

MariaDB [testdb]> INSERT INTO TBL2 VALUES (1);
Query OK, 1 row affected (0.00 sec)

MariaDB [testdb]> DROP TABLE TBL1;
Query OK, 0 rows affected (0.00 sec)

MariaDB [testdb]> DROP TABLE TBL2;
Query OK, 0 rows affected (0.00 sec)

MariaDB [testdb]> DROP DATABASE testdb;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> Bye