adding value to the table.

[Eshur]

hi,
i need to know if i can add in 1 more values into my table. My table looks like

| Field | Type | Null | key | Default | Extra |

----A------int-----NO---Pr--------0--------
----B------int----Yes------------Null------
----C------int----Yes------------Null------


Is it possible to add one more value, which is D, into the table? or i have to delete the table away and create a new one? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Reed]

I want to tell you that it's not "value" but it's called "column". "Values" are the things you store in "columns"

ALTER TABLE foo ADD COLUMN D INT; -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --