Hi,
The username field is text and number so you I can't autoincrement a
username like "abc003434" ...
----- Original Message -----
From: "Mohammad Shoja" <[EMAIL PROTECTED]>
To: "anna soobrattee" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 11:57 AM
Subject: Re: table locking and priorities
> Hi Anna,
>
> Why you dont use auto increment field,
> Without a sequence (in Oracle) or Autoincrement (in MySQL) how you will be
> sure about uniquness of your key ?
> Mohammad
>
>
> > Hi All,
> >
> > Can anyone help me...
> >
> > My registration form looks up the last username in the members table
(select
> > distinct username from members order by uid desc limit 1), and
increments
> > this username (e.g. from abc00002 abc00003) which will be used as the
> > username for the next user to sign up...
> >
> > the problem occurs when in the time it takes to do an insert, several
> > selects can take place - so i have the case where there are users with
the
> > same username (which is not very good at all)
> >
> > Can I force the selects to lock, whilst the insert is taking place? Has
> > anyone got any ideas on how to get aorund this ?
> >
> > Please write back soon!
> > Anna
> >
> >
>
> ----------------------------------------------------------------------
> Mohammadreza Shojatalab
> European Bioinformatics Institute Tel: +44 (0)1223 494 669
> EMBL Outstation Fax: +44 (0)1223 494 468
> Wellcome Trust Genome Campus E-Mail: [EMAIL PROTECTED]
> Hinxton, Cambridge URL: http://www.ebi.ac.uk/~shoja
> CB10 1SD, UK
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
