請問在MYSQL裡可以像ORACLE那樣設定FK嗎? 那如果可以的話，請問語法該如何下。

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(] LIKE old_tbl_name [)];    create_definition:     col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]             [[PRIMARY] KEY] [COMMENT 'string'] [reference_definition]   | PRIMARY KEY (index_col_name,...)   | KEY [index_name] (index_col_name,...)   | INDEX [index_name] (index_col_name,...)   | UNIQUE [INDEX] [index_name] (index_col_name,...)   | FULLTEXT [INDEX] [index_name] (index_col_name,...)   | [CONSTRAINT symbol] FOREIGN KEY [index_name] (index_col_name,...) [reference_definition] | CHECK (expr) --- Everything I say is a lie.

對不起哦，我還是有點看不太懂說~ 我有兩個table為, 我的Work裡的id欄位要設personalpersonal的FK 我該如何設定??? tablename:Personal COLUMN NAME TYPE CONSTRAIN id varchar(10) pk sex char(2) birthday date marriage char(4) address varchar(50) tablename:work COLUMN NAME TYPE CONSTRAIN name varchar(12) Not Null id varchar(10) (但此欄位要設定為personal的FK) jobname varchar(20) workday varchar(9)

實際完整範例如下: CREATE TABLE product (category INT NOT NULL, id INT NOT NULL, price DECIMAL, PRIMARY KEY(id)); CREATE TABLE customer (id INT NOT NULL, PRIMARY KEY (id)); CREATE TABLE product_order (no INT NOT NULL AUTO_INCREMENT, product_category INT NOT NULL, product_id INT NOT NULL, customer_id INT NOT NULL, PRIMARY KEY(no), INDEX (product_category, product_id), FOREIGN KEY (product_id) REFERENCES product(id) ON UPDATE CASCADE ON DELETE RESTRICT, INDEX (customer_id), FOREIGN KEY (customer_id) REFERENCES customer(id));