Legolas Woodland wrote: > Hi > Thank you for reading my post. > I have a table with one identity column , so Derby will generate a > value for this column in evry insert. > what should i do if i need to make some record with customized ID ? > for example i want my admin user to have id=1 ? how i should insert it ? > This search is a bit trickier because it is not how you insert the value but how you create the table that is the trick. Look carefully in the reference manual at the page you referred to create your identity column and see if it doesn't give you your answer.
I left out an important step when I posted before about searching for information. Not only is it good to search documentation before posting , but if you are unable to find what you need, please let us know what you tried and what you found so far. That way, folks will know that you made a solid effort to research the effort yourself first. It will also clarify the question for those responding and help us improve the documentation to support the searches that users are likely to make. Thanks for using Derby! Kathey
