I am just after exporting a database from Access into MySQL. Im using the MySql Control center to do the work. There doesn't seem to be any tool for creating relationships in MySQL or any reference to foreign keys. Do I assume that when I imported the database from access, MySQL automatically recognises the relationships I have created in Access. Any help would be of significant value.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing from Access
- Thread starter dowlin3
- Start date
sleipnir214
Programmer
Do not assume that.
Explicit foreign keys are only supported in MySQL 3.23.44 on InnoDB-type tables. Take a look here:
Want the best answers? Ask the best questions: TANSTAAFL!
Explicit foreign keys are only supported in MySQL 3.23.44 on InnoDB-type tables. Take a look here:
Want the best answers? Ask the best questions: TANSTAAFL!
- Status
Similar threads