2022 Developer Survey is open! Take survey.

New answers tagged

1 vote

How to design a database that merges two similar others?

The usual way is to add all the column into the merged tables and leave unused columns null. In practice, you should also consider how data are merged in the new DB: How to identify the same person or ...
user avatar
  • 241
0 votes

Delete entry from related tables

DELETE CASCADE: When we create a foreign key using this option, it deletes the referencing rows in the child table when the referenced row is deleted in the parent table which has a primary key. ...
user avatar

Top 50 recent answers are included