Sqlite: Select Into

SELECT INTO statement in sqlite

sqlite does not support SELECT INTO.

You can probably use this form instead:

INSERT INTO equipments_backup SELECT * FROM equipments;

SQlite: select into?

You can try this query:

insert into bookmark1 select * from bookmark

SQLite equivalent of SELECT ... INTO in Access SQL

As mentioned in this answer to a similar question, SQLite supports

CREATE TABLE table2 AS SELECT * FROM table1

which you can use in place of the SELECT ... INTO table2 FROM table1 form that Access SQL uses.

sqlite insert into table select * from

explicitly specify the column name in the INSERT clause,

INSERT INTO destinationTable (risposta, data_ins)
SELECT STATUS risposta, DATETIME('now') data_ins 
FROM   sourceTable

sqlite3 INSERT INTO UNION SELECT

You should explicitly specify which columns in table1 your insert is targeting:

INSERT INTO table1 (field1, field2, timestamp)
SELECT 'hello', 15, 1262340000
UNION ALL
SELECT 'byebye', 10, 1262340000
UNION ALL
SELECT 'hi', 20, 1262340000
UNION ALL
SELECT 'boo', 25, 1262340000;

When you omit the select list entirely, SQLite will fall back to expecting values for all columns in the table, in the exact order specified by the table definition. In your case, as you only provided values for 3 out of the 4 total columns, you get an error. Note that you could have also used VALUES here:

INSERT INTO table1 (field1, field2, timestamp)
VALUES
    ('hello',  15, 1262340000),
    ('byebye', 10, 1262340000),
    ('hi',     20, 1262340000),
    ('boo',    25, 1262340000);

Use SQLite SELECT to combine joined table column into one row for each category using a junction table

You must join Categories to Reference first and then to Items, with LEFT joins, just in case a category does not have any items related and then aggregate with GROUP_CONCAT():

SELECT c.name,
       GROUP_CONCAT(i.name || ' - ' || i.status, ', ') Related
FROM Categories c
LEFT JOIN Reference r ON r.cat_id = c.id
LEFT JOIN Items i ON i.id = r.item_id
GROUP BY c.id, c.name

See the demo.

Results:

| name  | Related                        |
| ----- | ------------------------------ |
| wet   | river - north fork, lake - big |
| dry   | desert - mojave                |
| metal | car - ford, truck - chevy      |

Sqlite INSERT INTO ... SELECT using ORDER BY

The documentation says:

If a SELECT statement that returns more than one row does not have an ORDER BY clause, the order in which the rows are returned is undefined.

So it does not make much sense to change the order in which rows are stored, because you'd have to put the same ORDER BY on the queries used to read the data later.

Anyway, the error is that 'TRACE_NUM' is a constant string. To refer to the contents of the column, use TRACE_NUM.

SQLITE - Insert Select not working?

Using the example provided here I suggest you use the following syntax:

INSERT INTO Parts_list (_id, table_owner, etc) 
SELECT null, 'My Name', etc 
FROM tracking_vehicles

List out all your columns as I've started to and then pass through all the values in the SELECT.

---

Related Topics