MySQL 错误 1064 内连接

Question

我写了这个SQL:

INSERT INTO registered (`idc`, `idp`, `date`)
SELECT 'idc' 
FROM course,registered
    INNER JOIN course c ON c.idc=registered.idc 
WHERE course.title='aaa',
      (SELECT `idp` FROM participant,registered
      INNER JOIN participant ON participant.idp=registered.idp WHERE 
      participant.username='mmm')

我收到此错误:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' (SELECT idp FROM participant,registered INNER JOIN participant ON pa' at line 4

Answer 1

类(class)idc int(11)PRI 自动增量标题 varchar(200) UNI详细文字参与者idp int(11)PRI 自动增量名字 varchar(50)姓氏 varchar(50)用户名 varchar(100)UNI挂号的idc int(11) 无符号 PRIidp int(11) 无符号 PRI日期日期