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 PROTECTED]> wrote: > 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 18:13:54 -0500, Ed <[EMAIL PROTECTED]> wrote: > > 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 > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
