java - mysql查询错误insert joined select

Question

您好，我的 mysql 查询有问题我想插入连接选择查询的结果和另一个数据

这是我的查询请检查并告诉我

    INSERT INTO TB_AUTO_BAN    (MEMO,    REG_DATE,    USER_ID,    NAME,    PHONE_NUM    )    VALUES(    'test',    NOW(),    SELECT    a.USER_ID, a.NAME, a.CONTACT_NUM    FROM TB_CONTACT AS a INNER JOIN TB_CONTACT_GROUP AS b     ON a.GROUP_CONTACT_SEQ = b.GROUP_CONTACT_SEQ     WHERE b.USER_ID= 'spark@naver.com' AND b.GROUP_CONTACT_SEQ = 12000)

Answer 1

正确的语法如下

  INSERT INTO TB_AUTO_BAN
    (MEMO,
    REG_DATE,
    USER_ID,
    NAME,
    PHONE_NUM
    )

    SELECT 
    'test',NOW(),
    a.USER_ID, a.NAME, a.CONTACT_NUM
    FROM TB_CONTACT AS a INNER JOIN TB_CONTACT_GROUP AS b 
    ON a.GROUP_CONTACT_SEQ = b.GROUP_CONTACT_SEQ 
    WHERE b.USER_ID= 'spark@naver.com' AND b.GROUP_CONTACT_SEQ = 12000