CODEWITHSUNDEEP
phpmysql
jeffmangum
jeffmangum

Reputation: 103

Merge two tables with different structure into one

enter image description here

That is the structure of my original employees table .

This is the employees table from a different database that i want to be merged with my original employees table: enter image description here

Its tricky because they have different structures. I was thinking of just adding the columns from the new employees table to the original employees table.

Upvotes: 0

Views: 173

Answers (1)

GGio
GGio

Reputation: 7653

What i would do is drop both tables and create NORMALIZED TABLES. Right now both of the tables are not normalized and if you perform a lot of queries on these tables it will be slow.

Instead you can split both tables and get necessary info for example:

   Users Table Columns (ID, UserName, Password, CreateDate etc...)
   Users Info Table Columns (ID, FirstName, LastName, Gender, Age etc....)
   User Activation Table (ID, UserActive, ActivationDate, DeActivationDate etc.)

and use foreign keys to reference to ID from other 2 tables. Read up on relational databasees

Upvotes: 1

Related Questions