Hi, i have a user table (id - int, primary key, name - varchar, thumb - varchar).
When i create a user, i want to save thumb name prefixed with id. ex: 1, 'test user', '1_thumb.png'
I know that after inserting a record only i'll get its id. and updating thumb prefixing id (means TWO operations on each create user). I would like to the best practices in this regard... when there are many users trying to create their profile.
thanks in advance.