14 comments

• 

  nilesh

  7 months ago

  Thanks. it helped me.
  reply
• 

  Philip

  7 months ago

  Wow, that's kind of stupid that there's no before.
  reply
• 

  James

  6 months ago

  Why do you need a before? If its the first one, you use first, if its the second one, you use after first.
  reply
• 

  ally

  2 months ago

  wow, you have no idea what you're talking 'bout
  reply
• 

  fubar

  6 months ago

  nice
  reply
• 

  Mike

  5 months ago

  Thus why philip will never design anything worth while. Positive thinking is needed to create great things .... :P
  reply
• 

  Parkash

  5 months ago

  Wow what a solution!
  reply
• 

  KG Old Wolf

  5 months ago

  Actually "HEAD FIRST SQL" (book by O'Rielly publications) states there is "BEFORE, AFTER, FIRST, SECOND, THIRD" but I can only get FIRST and AFTER to work using MySQL 5.1
  
  That's why I came here for a different opinion.
  
  I think the book is wrong :(
  reply
• 

  BaZ

  5 months ago

  Try looking at MySQL refman page:
  http://dev.mysql.com/doc/refman/5.1/en/alter-ta...
  The location, if present, must be "FISRT" or "AFTER column", there is no other option.
  
  If the book is about MySQL 5.1 its really wrong, but isn t it about ANSI SQL or anything else?
  reply
• 

  bob

  4 months ago

  This is just perfect, I use it all the time ... thx!
  reply
• 

  gb

  3 months ago

  Thanks!
  reply
• 

  gnujack

  2 months ago

  Thanks, exactly what I was looking for!
  reply
• 

  mike

  2 months ago

  "...with a datatype of VARCHAR(80), use the..." then you say "...ADD email VARCHAR(60)" what i'm getting at here is 80 then 60. small typo.
  reply
• 

  andy

  1 month ago

  @KG - SQL comes in many flavors. PregreSQL and MySQL and MS SQLServer all use slightly different variations on SQL, with varying support for various language constructs. I can only assume they are all derived from some original SQL language specification.
  reply