mysql> CREATE TABLE nicks (nick VARCHAR(30), pilot VARCHAR(30) NOT NULL, PRIMARY KEY (nick), FOREIGN KEY (pilot) REFERENCES pilots(pilot) ON DELETE CASCADE);
Query OK, 0 rows affected (0.01 sec)

mysql> select * from pilots;
Empty set (0.01 sec)

mysql> insert into nicks ('a', 'b');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''a', 'b')' at line 1
mysql> insert into nicks values ('a', 'b');
Query OK, 1 row affected (0.00 sec)

mysql> select * from nicks;
+------+-------+
| nick | pilot |
+------+-------+
| a    | b     |
+------+-------+
1 row in set (0.00 sec)

mysql>