|
<< Click to Display Table of Contents >> INSERT INTO and Primary Keys and Autoinc |
  
|
|
<< Click to Display Table of Contents >> INSERT INTO and Primary Keys and Autoinc |
|
The Primary Key/Primary Index fields, whatever as INTEGER or AUTOINC fields, do not accept inserting specific values via e.g.
INSERT INTO TableName (Field1, Field2, etc.) VALUES (value1, value2, etc.);
whereas inserting values including the to Primary Key/Primary Index fields may be done through SELECT statements as e.g.:
INSERT INTO TableName SELECT * FROM SourceTable;
__________________________