Thank you very much
"alter table Employees drop primary key;" was the clue I needed. alter table recovery add recnum mediumint(9) auto_increment NOT NULL primary key; finished the job. This saved me from having to write a program to modify a mysqldump of 600,000 record 

Mysql Alter Column Primary Key
Mysql Alter Column Primary Key       Mysql Alter Column Primary Key is used to modify table... illustrate an example from 'Mysql Alter Column Primary Key'. To understand 

SQL Alter Table Primary Key
SQL Alter Table Primary Key       Alter a Table Primary Key in SQL modifies the existing table... table_name ADD PRIMARY KEY (column_name) Alter Table Primary 

Mysql Alter Table Primary Key
Mysql Alter Table Primary Key       Mysql Alter Table Primary Key is used to remove the primary key from the table and add primary key to the existing other column of table 

Mysql Alter Column
Mysql Alter Column       Mysql Alter Column is used to redefine the table and change the datatype... from 'Mysql Alter Column'. To understand an example from 'Mysql Alter Column', we 

Mysql Alter Add Column
demonstrate you 'Mysql Alter Add Column'. To understand this example, we... Mysql Alter Add Column       Mysql Alter Add Column is used to define the existing Table and add 

Mysql Alter Rename Column
Mysql Alter Rename Column       Mysql Alter Rename Column is used to modify the table definition... illustrate an example from 'Mysql Alter Rename Column'. To understand this example 

SQL Alter Table Primary Key tutorial
SQL Alter Table Primary Key       Alter a Table Primary Key in SQL modifies the existing table... table_name ADD PRIMARY KEY (column_name) Alter Table Primary 

Mysql Alter Unique Key
Mysql Alter Unique Key      ... The Tutorial illustrate an example from 'Mysql Alter Unique Key'. The example... KEY (`ID`)  ) Query to alter the column unique :  

Mysql Alter Column Size
Mysql Alter Column Size       Mysql Alter Column Size is used to change the data size of a column... Alter Column Size'. To understand example we create table 'employees 

Mysql Alter Column Datatype
Mysql Alter Column Datatype       Mysql Alter Column Datatype is used to modify the table and change... from 'Mysql Alter Column  Datatype'. To understand this example we create