List:General Discussion« Previous MessageNext Message »
From:Vikram A Date:July 21 2011 6:56am
Subject:Re: Next Unique Number - Generation
View as plain text  
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.martins@stripped>
To: Vikram A <vikkiatbipl@stripped>; MY SQL Mailing list
<mysql@stripped>
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 info@stripped
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" <vikkiatbipl@stripped>
To: "MY SQL Mailing list" <mysql@stripped>
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. 
Thread
Next Unique Number - GenerationVikram A21 Jul
  • RE: Next Unique Number - GenerationDaevid Vincent21 Jul
    • Re: Next Unique Number - GenerationPrabhat Kumar22 Jul
Re: Next Unique Number - GenerationVikram A21 Jul