mysql query error insert joined select

Question

hi i have problem on my mysql query i wanna insert result of joined select query and another data

this is my query check and advise me please

    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= '[email protected]' AND b.GROUP_CONTACT_SEQ = 12000)

Strawberry · Accepted Answer · 2014-07-25 10:04:31Z

4

The correct syntax is as below

  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= '[email protected]' AND b.GROUP_CONTACT_SEQ = 12000

edited Jul 25, 2014 at 10:04

Strawberry

34k14 gold badges43 silver badges57 bronze badges

answered Jul 25, 2014 at 9:55

Mudassir Hasan

29k21 gold badges104 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mudassir Hasan Over a year ago

forgot to remove the last bracket at end of select query..check edit

Collectives™ on Stack Overflow

mysql query error insert joined select

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related