【SQL学习笔记】二、MYSQL数据库创建表的主键与外键&查看表结构方法
1、创建表的主键
①单字段主键
mysql> use demo;
Database changed
mysql> create table stu(id int primary key,
-> name varchar(20),
-> sex boolean);
查看表结构
mysql> describe stu;
②多字段主键
mysql> create table stu_course(course_id int,
-> course_name varchar(20),
-> course_teacher varchar(20),
-> student_num int,
-> primary key(course_id,course_name));
查看表结构
mysql> desc stu_course;#desc为describe简写
2、创建表的外键
mysql> create table stu_score(stu_id int primary key,
-> course_id int,
-> course_name varchar(20),
-> score int,
-> constraint STU_SCORE_COURSE foreign key(course_id,course_name) references stu_course(course_id,course_name));
表详细结构
mysql> show create table stu_score\G;