mysql - 如何使用 select 语句向表中插入值

Question

我正在尝试将这些值插入到我的表学生中，但出现错误

insert into student(first_name,last_name,student_number,professor_id)
  values(Eden,Yuan,323744573, 
  select professor_id from PROFESSORS where professor_name =  'Chu ')

我收到错误

saying missing expression

Answer 1

您可以使用这种方式(假设Professor_id是您需要的列)

insert into student(first_name,last_name,student_number,professor_id) 
select 'Eden', 'Eden', 323744573, column_professor_id 
from PROFESSORS where professor_name = 'Chu ' ;

(您的查询中缺少选择中的列)