SQLite Insert value and select

Question

I need to insert a row like following:

INSERT INTO table1 (id, name) VALUES (1, SELECT otherName FROM table2);

Is it possible in SQLite?

I would suggest to be a bit more specific in your question. – Sebastian P. Jul 02 '15 at 08:06 — Sebastian P., Jul 02 '15 at 08:06
http://www.tutorialspoint.com/sqlite/sqlite_sub_queries.htm – Shivam Jul 02 '15 at 08:11 — Shivam, Jul 02 '15 at 08:11

score 4 · Accepted Answer · edited May 23 '17 at 12:29

4

Here is the syntax you are looking for:

INSERT INTO table1 (id, name)
SELECT 1, otherName
FROM table2

Have a look at this SO article which covers a similar question.

edited May 23 '17 at 12:29

Community

1
1

answered Jul 02 '15 at 08:08

Tim Biegeleisen

502,043
27
286
360

@XFreeUser Happy to help you out. – Tim Biegeleisen Jul 02 '15 at 09:34

score 1 · Answer 2 · answered Jul 02 '15 at 08:08

Coming from here : http://www.tutorialspoint.com/sqlite/sqlite_insert_query.htm

You can populate data into a table through select statement over another table provided another table has a set of fields, which are required to populate first table. Here is the syntax:

 INSERT INTO first_table_name [(column1, column2, ... columnN)]    
 SELECT column1, column2, ...columnN    
 FROM second_table_name   
 [WHERE condition];

Shivam · Answer 3 · 2015-07-02T08:24:45.527

0

This works :

INSERT INTO test2 values(1,(Select name from test1 where id=1))

Here i tested it on SQLite : http://sqlfiddle.com/#!5/9bcff/1

edited Jul 02 '15 at 08:24

answered Jul 02 '15 at 08:16

Shivam

457
1
6
15

score -1 · Answer 4 · edited Jul 27 '15 at 08:14

AM using java , so you can use some thing like this

prep = Db_Connector.connection.prepareStatement("insert into reg_member values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
            prep.setString(2, surname);
            prep.setString(3, lastname);         
            prep.execute();
            prep.close();
            Db_Connector.killObjects(Db_Connector.statement, Db_Connector.connection);

SQLite Insert value and select

4 Answers4