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
(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