suren v

suren v

  • NA
  • 113
  • 43.6k

How to store Phone Numbers ?

Jun 16 2013 11:11 AM
Hai, Good Evening Dudes,
 I need to store phone numbers in DB like this,

 I have one Emp table in that i have to store mobile numbers ,like this

Emp Tab:
-----------------

EmpId     EmpName  EmpPhoneNum
1               Siva            9123456789

Suppose one Employee have 2 or more mobile numbers means how to store it ? ? ? 

EmpId     EmpName  EmpPhoneNum
1               Siva            9123456789,9212345678,............

like this  and same time i want to update nums and also i want to delete particular number only... 

Thanks In Advance :) 





Answers (5)