Delete/Change table info (beginner)

I just made a table using "CREATE TABLE asdf (...);", and I forgot to specify the primary key. Also, how do I ADD/DELETE more columns? Thanks..

Nelson

You need to use the 'ALTER TABLE' statement.
To change a coloumn it's;

ALTER TABLE tablename MODIFY columnname column properties

ie:

ALTER TABLE user MODIFY id INT(11) PRIMARY KEY;

To add a column use ADD;

ALTER TABLE user ADD password VARCHAR(15) ...etc.

Kelvin.

OK, thanks. All the tutorials I found only told you how to CREATE, but not EDIT.. Now I suppose that to delete a column (for future reference) I use "ALTER TABLE tablename DELETE columnname"?

Use;

ALTER TABLE tablename DROP columnname;

Kelvin