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
Manas MohapatraPosted Apr 25, 2016, 4:44 AM
dipti katePosted Apr 25, 2016, 3:38 AM
Manas MohapatraPosted Apr 25, 2016, 3:09 AM