WmZilla - Webmaster and Marketplace

The Next Generation Webmaster and Trade Forum

Can anyone provide an example of a MYSQL database?

nureteru

New member

0

0%

Status

Offline

Posts

34

Likes

0

Rep

0

Bits

180

3

Months of Service

0%
Friends, I am encountering some errors while trying to adapt a mssql blog site database I saw on the internet to mysql. I am receiving the error 1215: "Cannot add foreign key constraint." Even though I applied the steps taken in mssql to mysql in the same way, this problem keeps occurring. If anyone has a database example suitable for a question-answer system or any blog site and is willing to share, I would greatly appreciate it. ISSUE RESOLVED! Let me explain how I solved the problem for those who will see this topic later... While the row format comes by default in heidisql, I noticed that it arrives dynamically in navicat. In navicat, I could easily add foreign keys, while in heidisql, it was not possible. After changing the default to dynamic in heidisql, the problem was resolved.
 

249

6,622

6,642

Top