create table student_table |
( |
# 为本表建立主键约束 |
student_id int auto_increment primary key, |
student_name varchar(255), |
# 指定java_teacher参照到teacher_table的teacher_id列 |
java_teacher int, |
foreign key(java_teacher) references teacher_table(teacher_id) |
); |