Re: Incorrect Primary Keys identified when converting from Access to MySQL

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]

Posted by Dan Wilson 76.182.39.190 on March 27 2008 19:32:05

In Reply to: Incorrect Primary Keys identified when converting from Access to MySQL posted by Dan Wilson on March 27 2008 19:23:44

Ok I think I found something else interesting. The software seems to accumulate the primary key strings throughout the batch generation. Notice how the list keeps getting larger?

PRIMARY KEY(AssignmentID)
PRIMARY KEY(AssignmentID,submittalID)
PRIMARY KEY(AssignmentID,submittalID,BUID)
PRIMARY KEY(AssignmentID,submittalID,BUID,peopleID)
PRIMARY KEY(AssignmentID,submittalID,BUID,peopleID,peopleAssignedToID)
.....
PRIMARY KEY(AssignmentID,submittalID,BUID,peopleID,peopleAssignedToID,projectID,ID,projectOwnerID,ID,projectTypeID,reportLineID,resourceTypeID,RoleID,SubBUID)

I hope this information was helpful...

Follow Ups:

Re: Incorrect Primary Keys identified when converting from Access to MySQL - Dave 20:42:04 March 27 2008 (0)

Post a Followup

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:
> Ok I think I found something else interesting. The software seems to accumulate the primary key strings throughout the batch generation. Notice how the list keeps getting larger? > > PRIMARY KEY(AssignmentID) > PRIMARY KEY(AssignmentID,submittalID) > PRIMARY KEY(AssignmentID,submittalID,BUID) > PRIMARY KEY(AssignmentID,submittalID,BUID,peopleID) > PRIMARY KEY(AssignmentID,submittalID,BUID,peopleID,peopleAssignedToID) > ..... > PRIMARY KEY(AssignmentID,submittalID,BUID,peopleID,peopleAssignedToID,projectID,ID,projectOwnerID,ID,projectTypeID,reportLineID,resourceTypeID,RoleID,SubBUID) > > > I hope this information was helpful... > >

Optional Link URL:
Link Title:
Optional Image URL:

Enter the code shown :

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]