Click here to subscibe to newsletter

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:23:44

The following table SQL was generated using batch mode and going from Access to mySQL. The column definitions are correct but the primary keys are not. I can provide additional details if necessary.

CREATE TABLE `DeveloperResourcesByProject` (
`projectID` int(11),
`month` int(11),
`year` int(11),
`tKey` varchar(255),
`DeveloperFTE` double,
`projectName` varchar(50),
PRIMARY KEY(AssignmentID,submittalID,BUID)
);


Follow Ups:



Post a Followup

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:

Optional Link URL:
Link Title:
Optional Image URL:

Enter the code shown :


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

Copyright © 1999-2004 David Birebent All Rights Reserved.