adding field

[Mr.X-PAS]

For some reason I need to add one more field in my DB. I have a shell access, a MySQL, only not know what exactly is the command in MySQL mode, because I am not skilled in MySQL.

Best Regards

[cech]

If you want to add each time one field in a table, use the following command:

mysql> alter table tablename add column columname char(10);

Where char(10) meant max number of character in field.
After commit the command line will dee notification lines:

Query OK, 1 row affected (0.04 sec)
Records: 1  Duplicates: 0  Warnings: 0

[Mr.X-PAS]

My table consists of several fields. How to add all their fields at time? After all this I want to be sure that everything is OK.

[cech]

Anytime you can see the contents of your table. In mysql command line type:

select * from yourtable;

There is a good example for multiply add columns:

alter table tablename add column columname1 datatype,add column columname2 datatype,add column columname3 datatype, add column columname4 datatype;

Where datatype can be:

TINYINT; SMALLINT; MEDIUMINT; INT; BIGINT; FLOAT; DOUBLE; DECIMAL; NUMERIC; DATE; DATETIME; TIMESTAMP; TIME; YEAR; CHAR; VARCHAR; TINYBLOB; TINYTEXTM; BLOB; TEXT; MEDIUMBLOB; MEDIUMTEXT; LONGBLOB; LONGTEXT

Do not forget, you can do this through SSH directly in mysql command line, or using phpMyAdmin Run SQL query/queries link.