mysql怎么定义外键

于 2008-11-01 18:03:09 发布

· 286 阅读

文章标签：

#MySQL

spring struts spring 专栏收录该内容

31 篇文章

订阅专栏

CREATE TABLE customer(  id int( 11  )  NOT  NULL  AUTO_INCREMENT ,
  name varchar( 255  ) ,
  lastname  varchar( 255  ) ,
  age int( 11  ),
  CONSTRAINT customer_pk PRIMARY KEY (id)) TYPE=INNODB;


CREATE  TABLE book( id  int( 11  )  NOT  NULL  AUTO_INCREMENT ,
title varchar( 255  ) ,author varchar( 255  ) ,
customer_fk int( 11  ),
available TINYINT NOT NULL,
   CONSTRAINT book_pk PRIMARY  KEY ( id ),//这里只是定义主索引，constranit是约束的意思
INDEX (customer_fk)  ) TYPE=INNODB;  //外键一定是要定义索引，且它一定是int或integer类型



//constraint约束 
 ALTER  TABLE book ADD  CONSTRAINT book_customer FOREIGN  KEY ( customer_fk ) REFERENCES customer( id )  ON  UPDATE  RESTRICT  ON  DELETE  RESTRICT ;//级联删除