MySQL Forums
Forum List  »  Microsoft SQL Server

Auto increment
Posted by: Krishan Madushanka
Date: October 11, 2015 12:06AM

I have a mysql table where in i have a field called patient_id which i do an auto increment and its the primary key !! since this number goes on patient card also simply 1,2 will not be good . Is there a way to prefix some text to it like patient1, patient2 something like that!!!

Options: ReplyQuote


Subject
Written By
Posted
Auto increment
October 11, 2015 12:06AM
October 14, 2015 01:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.