Topic: Insert next id

[owner]

Hello,

I am in need of a column where the numbers should be auto incremented if left null, but also allow for duplicate numbers if specified.  Is this possible?  If not, what would be the best way to go about it?  Right now the only way I know I could achieve this is to grab the last inserted id from the last query and then make a second query to update the column of the first one with the same id.

Thanks in advance!
owner

[Twister1004]

If you are going to use auto increment, then you can NOT have the same number or leave it null. It will call it a duplicate and disregard that SQL. I don't know exactly how to go about your question though.

[owner]

Is there a way to copy the value from an autoincrementing column to the second column without the need of the second query?

[fenway]

Besides, NULL in an auto-increment field will just insert the next number in sequence anyway.

And why would you duplicate information across columns????