Change Table Fields In MySQL?

[jtmerchant]

Is it possible to add, delete, and rename the fields of a table in MySQL?

[Drakla]

Yup, search for "Mysql ALTER TABLE" syntax in google.

[jtmerchant]

Ok say I have a field that is defined as such in my original CREATE TABLE query:

id int(11) NOT NULL auto_increment, PRIMARY KEY  (id)

When I SHOW COLUMNS I get row[0] with the name of the column, and row[1] with the type, ie.:
id
int(11)
So how do I grab all the other information (ie. "NOT NULL auto_increment, PRIMARY KEY (id)")?

EDIT: Nevermind, I got it. The reason I didn't get it first is because row[2] is NULL but row[3-5] work 😛

[Drakla]

You have to use SHOW CREATE TABLE mytable, then carve it up.