mysql> SHOW CREATE TABLE province \G

*************************** 1. row ***************************

? ? ? ?Table: province

Create Table: CREATE TABLE `province` (

? `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,

? `name` varchar(20) NOT NULL,

? PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

1 row in set (0.00 sec)

mysql> CREATE TABLE user1(

? ? -> id SMALLINT UNSIGNED KEY AUTO_INCREMENT,

? ? -> name VARCHAR(20) NOT NULL,

? ? -> pid SMALLINT UNSIGNED,

? ? -> FOREIGN KEY (pid) PREFERENCES province (id) ON DELETE CASCADE);

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 'PREFERENCES province (id) ON DELETE CASCADE)' at line 5

mysql> SHOW CREATE TABLE province;