Insert With Auto Increment Column

[bandi]

Hello,

I don't know if this has been addressed or not but here is the small issue i see.

If i have a table let's say user with user_id PK and auto increment and user_name etc other fields

when selecting on the Contextual Menu : PASTE SQL Statements -> INSERT into …

the insert statement pasted contains the user_id also in the insert:

insert into user (user_id,….) values (user_id,…..)

since this is a primary key with auto increment user id should NOT be present in this insert statement.

What do you think?

[peterlaursen]

It has not been adressed.

Actually it would be smart if we /* commented out */ such column. However with every column having a DEFAULT you could have similar wishes.

This is not priority!

[Author]

Posts