Re: suggestion needed for table design and relationship

2012-08-15 Thread Peter Brawley
cascade on delete cascade, ... ) engine=innodb; PB thx in advance. Rajeev From: Peter Brawley To: Rajeev Prasad ; "mysql@lists.mysql.com" Sent: Wednesday, August 15, 2012 4:01 PM Subject: Re: suggestion needed for table

Re: suggestion needed for table design and relationship

2012-08-15 Thread Rajeev Prasad
thx in advance. Rajeev From: Peter Brawley To: Rajeev Prasad ; "mysql@lists.mysql.com" Sent: Wednesday, August 15, 2012 4:01 PM Subject: Re: suggestion needed for table design and relationship On 2012-08-15 1:54 PM, Rajeev Prasad wrote: > I

Re: suggestion needed for table design and relationship

2012-08-15 Thread Peter Brawley
On 2012-08-15 1:54 PM, Rajeev Prasad wrote: I have to keep this data in MySql, and i am not sure (as SQL/databse is not my field) how to organise this into one or many tables? right now I would represent my info as follows: device_name|HW_version|SW_version|IP_addr_pvt|IP_addr_pub|data_specifi

suggestion needed for table design and relationship

2012-08-15 Thread Rajeev Prasad
I have to keep this data in MySql, and i am not sure (as SQL/databse is not my field) how to organise this into one or many tables? right now I would represent my info as follows: device_name|HW_version|SW_version|IP_addr_pvt|IP_addr_pub|data_specific_to_device|associated_service   |associated_