Inserting row into SQL table with some predefined values, and some from another table

Question

I am trying to insert a row into a table called "all_games" using SQLite. I have the values "game" and "money" where game is an integer and money is a string, however the middle value "players" is the value that I don't have, so I want to get it from another table that contains it.

This is the SQL Query that I am currently using:

INSERT INTO all_games (game, ... , money)
    SELECT (12, players, \'100, 200\') FROM games WHERE id=2

Just to clarify, "12" and "100, 200" represent values that I already have, I just want to get players from another table.

Thanks for any help in advance!

Marc Shapiro · Accepted Answer · 2013-05-21 23:06:42Z

1

I believe you just need to remove the second set of parentheses.

INSERT INTO all_games (game, players , money)
    SELECT 12, players, '100, 200' FROM games WHERE id=2

answered May 21, 2013 at 23:06

Marc Shapiro

5712 silver badges2 bronze badges

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

Collectives™ on Stack Overflow

Inserting row into SQL table with some predefined values, and some from another table

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