Re: Adding fields to db table (primary key and other type)

[Scott Klarenbach]

http://dev.mysql.com/doc/mysql/en/alter-table.html

ALTER TABLE dtd_test ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD
PRIMARY KEY (id);


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
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]