From: Eric Bergen Date: March 16 2005 8:05pm Subject: Re: Adding fields to db table (primary key and other type) List-Archive: http://lists.mysql.com/mysql/181374 Message-Id: <11b1bd99050316120565bac3b0@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Check out the alter table syntax in the manual at: http://dev.mysql.com/doc/mysql/en/alter-table.html On Wed, 16 Mar 2005 14:56:59 -0500, Ed wrote: > Hi all, > I am using MySQL Command Line and have created a table called dtd_test. It has two varchar fields at the moment. How can I add more fields? I want to add a primary key column which autoincrements, how can I do that? Thanks a lot > -- Eric Bergen eric.bergen@stripped http://www.ebergen.net