Inserting values from one table into specific fields in another table in SQLite3

Question

I have a feeling this is a simple error, but I do not know what I am doing wrong! I have one table in sqlite3 that has 33 fields, called "users" and want to import data for 7 of the fields from another table.

Here is what I am doing:

INSERT INTO users(id, username, password, firstName, lastName, email, membershipStart) SELECT(id, username, password, nicename, displayname, email, registered) FROM tempUSERS;

And then I get:

Error: near ",": syntax error

What is wrong with what I am doing?? -Raymosrunerx

Gordon Linoff · Accepted Answer · 2016-03-12 23:09:07Z

1

You don't need the parens in the select:

INSERT INTO users(id, username, password, firstName, lastName, email, membershipStart)
    SELECT id, username, password, nicename, displayname, email, registered
    FROM tempUSERS;

When the SQL parser encounters parentheses, it is expecting a scalar expression or subquery. Your expression is clearly not a subquery, and commas are not appropriate in a scalar expression.

answered Mar 12, 2016 at 23:09

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

Inserting values from one table into specific fields in another table in SQLite3

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