SQLite : insert multiple value (select from) with insert specified value

Question

i'm trying to make sqlite query that can insert multiple values , here's my query that i try :

    insert into table1(idy_table1,idx_table1) 
    values ('1',                               //specified value insert to idy_table1                               
    (select id_table2 from table2))            //insert value from select id_table2

i'm having some trouble, it just only insert one value,

and my question is how to make a proper query? so i can make it work.

CL. · Accepted Answer · 2014-06-16 20:32:04Z

2

The VALUES clause always adds one row. (Except when you're using multiple tuples, but this does not work with queries.)

The easiest way to add multiple rows from a query is to use the SELECT form of the INSERT statement:

INSERT INTO Table1(idy_table1, idx_table1)
SELECT '1', id_table2 FROM table2;

answered Jun 16, 2014 at 20:32

CL.

182k18 gold badges241 silver badges282 bronze badges

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

Collectives™ on Stack Overflow

SQLite : insert multiple value (select from) with insert specified value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related