Adding A new Field - MySQL

How can I add a new field (column) in an existing MySql Table ?
Please give SQL code
Thanks in advance

 

ALTER TABLE [I]tablename[/I] ADD [I]newfieldname[/I] [I]newfieldattributes[/I] AFTER [I]existingfield[/I]

Code (markup):

 

Thanks for quick reply, existingfield-? is it possible to add new field between existing fields?

 

sure why not?

say you want to insert the new field between existingfield1 and existingfield2, you would use existingfield1 in the sql statement:

ALTER TABLE tablename ADD newfieldname newfieldattributes AFTER [B][COLOR="Red"]existingfield1[/COLOR][/B]

Code (markup):

 

Thanks Again

 

Using phpmyadmin is the easiest way... but that query posted looks fine.

 

ya phpmyadmin is best

 

Thanks for this but can i know what are the field Attributes as i m new in mysql