dipti kate

dipti kate

  • NA
  • 23
  • 12.2k

how to split one table into 2

Apr 25 2016 3:03 AM
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)