...one field at a time
mysql 4.1.16-nt-max> alter
table table01 add column field03 char(20);
Query OK, 1 row affected (0.04 sec) Records: 1 Duplicates: 0 Warnings: 0
...more than one at a time
mysql 4.1.16-nt-max> alter table table01 add column field04 date,
add column field05 time;
Query OK, 1 row affected (0.04 sec)
Records: 1 Duplicates: 0 Warnings: 0
The "add column" must be restated for each column.
Commas are used between each add column statement.
A space may be used after these commas.
The MySQL Manual fully explains each possible column data type .
Did it work?
mysql 4.1.16-nt-max> select * from
table01;
| field01 |
field01 |
field01 |
field01 |
field01 |
| 1 |
first |
null |
null |
null |
Now we're getting somewhere! |
