Re: [sqlite] Insert into with select not working

Hello Brian, you do not need a VALUE keyword in this case. INSERT INTO "subscribers_new" --VALUES <- remove this SELECT id, ip_address, added, 'aa:bb:cc:etc' from subscribers; See the syntax diagram for the insert command: http://www.sqlite.org/lang_insert.html Martin Brian

[sqlite] Insert into with select not working

Can anyone explain to me why an insert with select statement isn't working? I know in my my example below I just have an extra column which I could have added, but my actual tables are a bit more complex and this below is just to demonstrate the problem. -- Original table CREATE TABLE