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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]