• Registered: 2015-11-13
  • Posts: 652

Topic: MySql and MVD Table Definition Question

Dimitry,

If I have an existing MySQL database and I want to create an MVD project to access the existing MySQL database, how do I get the MySQL table definitions into the MVD development environment on the "Database Tables" tab?

  • Registered: 2014-02-14
  • Posts: 10,294

Re: MySql and MVD Table Definition Question

Hello,


It's possible, if your database structure corresponds to two rules.


1. Every database table must have primary key `id` (id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT)


2. The name of the foreign key must be like:
if you have two tables tableA and tableB, foreign key in tableA must have name `id_tableB`


if your database structure is ok, you can create project and create same database structure in My Visual Database then simply connect your project to your exists MySQL database.

Dmitry.
  • Registered: 2015-11-13
  • Posts: 652

Re: MySql and MVD Table Definition Question

Ok. Thank you Dinitry.