Alter Column syntax help 1

[litton1]

Trying to move a DB from SQLExpress to MySQL

I am making a simple table to get my head around the syntax

create table Product
(
  ProductID int not null,
  ProductID_Parent int default null,
  Name varchar(50)
) type=InnoDB;

but having some problems with creating the PK which needs to be separate from the Table definitions.
Any help appreciated.

ALTER TABLE Product
    Alter Column ProductID INT NOT NULL AUTO_INCREMENT Add "FK_Product" PRIMARY KEY

Age is a consequence of experience

 

[r937]

which needs to be separate from the Table definitions"

why?

r937.com | rudy.ca

 

[litton1]

thx for your reply and sry that should say

ALTER TABLE Product
    Alter Column ProductID INT NOT NULL AUTO_INCREMENT Add "PK_Product" PRIMARY KEY

Why... because that is what has been asked of me.

Age is a consequence of experience

 

[r937]

ALTER TABLE Product
CHANGE COLUMN ProductID
ProductID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY


r937.com | rudy.ca

 

[litton1]

That did the trick. Thanks!

Age is a consequence of experience