Question

MYSQL可否将外键设为主键？

这是SQL server 的，我想转换为MYSQL，请问如何转换?
foreign key(course_NO) references course(course_NO),
foreign key(teacher_ID)references teacher (teacher_ID),primary key(course_NO,teacher_ID));

Answer 1

应该是可以的啊.

mysql> CREATE TABLE course (
-> course_NO INT PRIMARY KEY
-> );
Query OK, 0 rows affected (0.19 sec)

mysql>
mysql> CREATE TABLE teacher (
-> teacher_ID INT PRIMARY KEY
-> );
Query OK, 0 rows affected (0.08 sec)

mysql> CREATE TABLE temp (
-> course_NO INT,
-> teacher_ID INT,
-> foreign key(course_NO) references course(course_NO),
-> foreign key(teacher_ID)references teacher (teacher_ID),
-> primary key(course_NO,teacher_ID)
-> );
Query OK, 0 rows affected (0.10 sec)

Answer 2

应该可以的吧