Thanks Joerg. You are very correct.
On Thu, Oct 1, 2009 at 2:40 PM, Joerg Bruehe <Joerg.Bruehe@stripped> wrote:
> Hi!
>
>
> prabhat kumar wrote:
> > You can use :
> >
> > *ALTER TABLE it ADD COLUMN title varchar(25), phone number integer (6);*
> >
> > it will add new column after last.
> >
> > but you can also specify the particular column after you want to add.
> >
> > like.
> >
> > *ALTER TABLE it ADD COLUMN title varchar(25), phone number integer (6)
> AFTER
> > pusername; *
>
> The syntax is correct, but one data type is wrong:
>
> A phone number is no numeric type, it is a string of (mostly) digits.
>
> Those who think there is no difference, they are wrong:
> 1) In a phone number, you may need a leading zero. No numeric type
> supports that, unless you try some formatting which would then affect
> all values and not just selected ones.
> 2) Just ask yourself whether it makes sense to compute the average phone
> number (yes, the term is misleading).
>
> Similar reasoning applies to other digit strings, like article number,
> ISBN (books), SSN (social security number), passport number, etc.
>
>
> Jörg
>
> --
> Joerg Bruehe, MySQL Build Team, Joerg.Bruehe@stripped
> Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin
> Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel
> Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
