Hi Neil, thank you for your response, The admission number/register number will contain text/symbol(-,/,#). Is it possible to keep this as increment ?
________________________________ From: Neil Martins <neil.mart...@exactuscorp.co.in> To: Vikram A <vikkiatb...@yahoo.in>; MY SQL Mailing list <mysql@lists.mysql.com> Sent: Thursday, 21 July 2011 12:06 PM Subject: Re: Next Unique Number - Generation Hi in ur database define the 2 numbers as auto increment. Neil Martins Exactus Corporation Pvt. Limited ISO 9001:2000 certified 1st floor, Raheja Plaza, LBS Marg, Ghatkopar (West), Mumbai 400 086 India T: (9122) 66505900 F: (9122) 22040826 Url:www.exactuscorp.com -------------------------------------------------------------------------------- DISCLAIMER and CONFIDENTIALITY CAUTION This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Unauthorized reading, dissemination, distribution or copying of this communication is prohibited. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by telephone at (9122) 66505900 or email us at i...@exactuscorp.com and promptly destroy the original communication. Thank you for your cooperation. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Communicating through email is not secure and capable of interception, corruption and delays. Anyone communicating with Exactus Corporation Limited by email accepts the risks involved and their consequences. The recipient should check this email and any attachments for the presence of viruses. Exactus accepts no liability for any damage caused by any virus transmitted by this email. ----- Original Message ----- From: "Vikram A" <vikkiatb...@yahoo.in> To: "MY SQL Mailing list" <mysql@lists.mysql.com> Sent: Thursday, July 21, 2011 11:48 AM Subject: Next Unique Number - Generation Hi there, I need a technical help fro you, I have developed a software for college & school. Here we have concept called register number/admission number. These are two unique umber for each student. My application resides Client/server model. These numbers will be generated (some defined format) to each student when they are admitted at first time. This admission process is taken place at different nodes at a time. In this scenario, I am facing difficulty that, the same number is generated at time in two machines. (Logic is newest number will be displayed in the node before admission). How can I stop this logical issue? Can i have solution for this? Thank you in advance.
