CODEWITHSUNDEEP
sqlsqlite
user3599629
user3599629

Reputation: 227

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

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.

Upvotes: 1

Views: 44

Answers (1)

CL.
CL.

Reputation: 180040

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;

Upvotes: 2

Related Questions