MySQL 创建主键,外键和复合主键的语句

MySQL 创建主键,外键和复合主键的语句

作者： 字体：[ 增加  减小] 类型：转载

MySQL 创建主键，外键和复合主键的方法，需要的朋友可以参考下。

id="cproIframe_u1892994_2" width="580" height="90" src="http://pos.baidu.com/acom?adn=3&at=231&aurl=&cad=1&ccd=24&cec=GBK&cfv=17&ch=0&col=zh-CN&conBW=0&conOP=1&cpa=1&dai=2&dis=0&ltr=http%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3Dnn2sWueTrLn8U4FYdRfeimyKqLcjtZRPWkdMi0JVMlwgT_CQzUDQAjPsN__-HcKL%26wd%3Dmysql%25E5%2588%259B%25E5%25BB%25BA%25E4%25B8%25BB%25E9%2594%25AE%25E7%25BA%25A6%25E6%259D%259F%25E8%25AF%25AD%25E6%25B3%2595%26issp%3D1%26f%3D8%26ie%3Dutf-8%26tn%3Dbaiduhome_pg%26inputT%3D5022&ltu=http%3A%2F%2Fwww.jb51.net%2Farticle%2F21382.htm&lu_161=0&lunum=6&n=jb51_cpr&pcs=842x485&pis=10000x10000&ps=490x35&psr=1440x900&pss=1000x491&qn=faf892daee8d2205&rad=&rsi0=580&rsi1=90&rsi5=4&rss0=%23FFFFFF&rss1=%23F7FCFF&rss2=%230000ff&rss3=%23444444&rss4=%23008000&rss5=&rss6=%23e10900&rss7=&scale=&skin=tabcloud_skin_3&stid=5&td_id=1892994&titFF=%E5%AE%8B%E4%BD%93&titFS=12&titTA=left&tn=text_default_580_90&tpr=1427269287353&ts=1&version=2.0&xuanting=0&dtm=BAIDU_DUP2_SETJSONADSLOT&dc=2&di=u1892994&tt=1427269287339.327.450.450" align="center,center" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true">

1.创建主键语法 

ALTER TABLE table_name ADD CONSTRAINT pk_name PRIMARY KEY(列名); 

2.创建外键语法 

ALTER TABLE news_info[子表名] ADD CONSTRAINT FK_news_info_news_type[约束名] FOREIGN KEY (info_id)[子表列] REFERENCES news_type[主表名] (id)[主表列] ; 

3.使用组合主键 

如果一列不能唯一区分一个表里的记录时，可以考虑多个列组合起来达到区分表记录的唯一性，形式 

①创建时：create table sc ( 
studentno int, 
courseid int, 
score int, 
primary key (studentno,courseid) ); 
②修改时：alter table tb_name add primary key (字段1,字段2,字段3);