Insert multiple rows from other table - "Subquery returns more than 1 row"

Question

I table 1 contains:

    |col1|
    | 1  |
    | 2  |
    | 1  |
    | 3  |
    | 1  |
    | 2  |
    | 4  |
    | 2  |
    | 3  |
    | 1  |

and I have another table has a column name val, and my code is

INSERT INTO table2(value) VALUES ((select distinct col1 from table1))

I got the #1242 - Subquery returns more than 1 row.
How can I get multiple rows insert into my table2 ?

possible duplicate of Insert into table with multiple values in subquery — user2864740
– user2864740, Commented Apr 19, 2014 at 18:50

Gordon Linoff · Accepted Answer · 2014-04-19 18:45:57Z

6

You don't need the values statement when using insert . . . select:

INSERT INTO table2(value)
    select distinct col1
    from table1;

answered Apr 19, 2014 at 18:45

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

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

Comments

Mudassir Hasan · Accepted Answer · 2014-04-19 18:45:51Z

4

INSERT INTO table2(value)
select distinct col1 
from table1

answered Apr 19, 2014 at 18:45

Mudassir Hasan

29k21 gold badges104 silver badges135 bronze badges