I decided to add a primary key to a table after I created the table. This was fine until i wanted to add additional columns to the table.

Now I can't figure out how to insert a row.

Insert into MyTable( "Value 1", "Value 2", Primary key, "Value 3", "Value 4" )

Is there a placeholder that I can put in the primary key column that will work or is my only option to rebuild the table. I'll have to rebuild it at some point but it's still growing so I'd like to postpone rebuilding it until it stabilizes some.


Just add a column list explicitly :

 INSERT INTO MyTable (field1, field2,field3,... ) VALUES ('Value1', 'Value2', ...);

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.