How to insert into table using foreign key?

Question

SQL

Let's say there are 2 tables, with strings in brackets: teacher(id,name) and student(teacher_id,name), where the teacher_id string uses a foreign key from the teacher's id database. Please help, what query can be used to insert values ​​into the student table when adding a new student?

Answer 1

create table teacher(
  id int primary key,
  name varchar(64)
);

create table student(
  teacher_id int, 
  name varchar(64), 
  foreign key (teacher_id) references teacher(id)
);

insert into teacher (id, name) values (1, 'Teacher');

insert into student (teacher_id, name) values (1, 'Me');

select *
from student s
join teacher t on t.id = s.teacher_id
;

Test SQL query online