Hi All.I delete user account to mistake..how to fix or create user account ?I need user ... id 8 :(
Hello,
You are not able to create user again with same Id and Id is auto increment by default but you can create same use with same details again with new Id then make required changes to Employee table to link employee data to new user Id.
If you have a daily backup from this database you can restore database again but take care if its production database so may be some transactions will be dropped.
Thanks you for your replyIs it impossible to make the same as the deleted user's id?
Hello @Hyosang lee
As @Mostafa Othman mentioned you are not able to create user again with same Id and Id is auto increment by default.
So, if you want the user whose UserId was 8, you can create the a new user with same details but its ID will not be 8.
Thanks
Anees