sqlite insert into: do the column names have to match?

Posted by P a u l on Stack Overflow See other posts from Stack Overflow or by P a u l
Published on 2010-06-03T20:13:11Z Indexed on 2010/06/03 20:14 UTC
Read the original article Hit count: 115

Filed under:
|

(This question is specific to SQLite3, but it may be common to all SQL I don't know.)

This doesn't seem to work. Is it because the column names don't match? (If they match, it works.) If this is true, how can I select from a different field in the source table?

INSERT INTO [ImagePoint] (ImageID, PointID, X, Y) SELECT Image2ID, PointID, X, Y FROM Point

© Stack Overflow or respective owner

Related posts about sqlite

Related posts about sqlite3