Anonymous

create table mesto
    (mid   varchar(3),
     ime   varchar(10),
     primary key(mid)
    );

mysql> describe mesto;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| mid   | varchar(3)  | NO   | PRI |         |       |
| ime   | varchar(10) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.01 sec)



mysql> show tables;
+----------------------+
| Tables_in_seminarska |
+----------------------+
| mesto                |
+----------------------+
1 row in set (0.00 sec)

mysql> create table oseba
    ->     (oid varchar(3),
    ->      priimek varchar(10),
    ->      mid varchar(3),
    ->      primary key(oid),
    ->      foreign key(mid) references mesto
    ->     );
ERROR 1005 (HY000): Can't create table '.\seminarska\oseba.frm' (errno: 150)
mysql>