3
Answers

how to split one table into 2

dipti kate

dipti kate

8y
256
1
hii,
I need to break one table into two new tables I created.
table:AllInfo(old table) 
id,CompanyName,website,ContactName,Email,Address,PhNo
 
The above is the old table. Now I created two tables to hold the data, one table for CompanyInfo and another table for ContactInfo.Like below:
Table:Companyinfo
CompanyId,CompanyName,website,Address
 
Table:ContactInfo
ContactId,CompanyId,ContactName,Email,PhNo
Answers (3)