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