How to add columns in an existing table in phpmyadmin

[glady]

Hi,
How can i add(append) extra columns to a table using phpmyadmin? or through coding?
Thanks.

[ronverdonk]

- click the db at the left side of the screen, tables are shown
- click the table name at the left side of the screen
- all columns are displayed at right hand side of screen
- below the column display there is a row

Add  field(s)At End of Table At Beginning of Table After column_name GO

At that line you can add a new column to the show table.

Ronald :cool:

[glady]

- click the db at the left side of the screen, tables are shown
- click the table name at the left side of the screen
- all columns are displayed at right hand side of screen
- below the column display there is a row

Add  field(s)At End of Table At Beginning of Table After column_name GO

At that line you can add a new column to the show table.

Ronald :cool:

Thanks a lot !!!!:-)

[glady]

Thanks a lot !!!!:-)

Hey ,How could i do the same using coding?

[guruparthi]

For add column:

ALTER TABLE table_name add COLUMN column_name varchar(30)

For add column after specific filed,

ALTER TABLE table_name add COLUMN column_name varchar(30) AFTER column_name

For add column at first

ALTER TABLE table_name add COLUMN column_name varchar(30)FIRST

<Snip>

[johndavid19]

You can add column after particular field. The mysql query is

alter table table_name add column col_name datatype(length) after field_name

where, you need to use "after" keyword

Similarly, you can also add column at first of table. the query is

alter table table_name add column col_name first

Here you need to use "first" keyword