Thanks for the replies, works fine, I checked out the alter table syntax and
added a new field. How can you add two new fields I tried with
ALTER TABLE DTD_Test add template_header varchar(255), template_footer
varchar(255);
but i get an error. Cheers
See my original post:
ALTER TABLE dtd_test ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD
PRIMARY KEY (id);
Primary key could've just as easily been another column. You have to
include another ADD command after the comma.
On Wed, 16 Mar 2005 15:25:14 -0800, Scott Klarenbach
[EMAIL